Office documents are one of the most used programs worldwide since they fulfill one of the most basic functions, which is to allow the creation of text documents. One in particular is LibreOffice which is one of the most powerful and easy to use open source document file reader programs; And best of all, it’s free to download .
There is a specific program called Calc, which is the version of Excel in LibreOffice, whose tools can be very useful. One of them, which is the one that we are going to show you below, which is to easily compare two lists or columns with Calc. Although it also has certain interesting functions such as configuring and printing two pages per sheet .
Not sure how to compare two lists or columns in Calc? You are not the only one so don’t worry if you don’t already know that we will help you. We will guide you through the process you must do to be able to compare two lists in Calc easily and quickly with a simple procedure to do.
What is LibreOffice?
New to LibreOffice? If you don’t know it, don’t worry, we’re going to tell you what LibreOffice is and what advantages it has over other programs of this style. This way you will know what it is and understand more the information that we will provide you, since you will see the subject from a broader perspective.
LibreOffice is open source software developed by The Document Foundation for Windows , macOS, and Linux operating systems . This started first as a diffraction of OpenOffice.org and was later acquired by Sum Microsystem in August 1999.
These programs differ from the others, since being open source you can find various tools and extensions for them for free that can even help you find and eliminate duplicate values . Today we are going to talk about Calc and how to compare two lists or columns, so if you don’t have the program, download it to your pc to follow our steps.
How to compare two lists or columns in Calc easily?
Comparing two lists in Calc is a routine operation in any spreadsheet , surely for this reason you want to learn how to do it in Calc. The procedure is very simple, you just have to follow the steps that we will give you below and you can do them without any problem.
First things first, go to the spreadsheet you want to compare and open it to begin the procedure. Then Click on the cell of one of the columns that you want to compare and go to format that is in the menu above.
Then go to “conditional format” and then to “condition”, and in the box that will appear you must select in condition 1 the section “The formula is”. Then you must enter the comparison formula that will be written in the following way, you have to first put COUNTIF.
Now in parentheses you must place the values of the second column which will be compared with the first in this way ($ E $ 3: $ E $ 30; B3)> = 1 . In the example you can see that $ E $ 3: $ E $ 30 covers the values of the second column from the first box to the last box where you will have text if this is the case.
And we also have B3 -> = 1 that represents the second box, this formula means that if the range E3: E30 appears in cell B3 it must return the value ” true “. All that remains is to add the highlighting and for this you will have to display the options in “Apply style” and click on “New style”.
Now go to the “Background” tab and then choose a background color so that cells with the same value are highlighted, and then click “OK”. The next thing you should do is extend these formulas to the other cells and for this you will only have to go to the brush tool with cell 1 selected.
Then simply drag the brush over the other cells and thus the value that you put in cell 1 will be compared with the range of cell 2. Then simply repeat these steps for list two with the only difference that the formula for 2 would remain something like COUNTIF ($ B $ 3: $ B $ 30; E3)> = 1. And voila, if you correctly followed the aforementioned steps, you will have the result you expected.