Skip to content

How to Compare Two Lists or Columns in LibreOffice Calc Easily

22 de April de 2021

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 to you. 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 do not worry if you do not already know that we will help you. We will guide you through the process you must do in order to compare two lists in Calc easily and quickly with a simple procedure to do.

What is LibreOffice?

LibreOffice software package and logos

New to LibreOffice? If you do not know it, do not worry, we will tell you what it is LibreOffice and what advantages it has over other programs of this style. This way you will know what it is and understand more about 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 the Windows operating systems, macOS AND Linux. 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?

spreadsheet and different graphics in LibreOffice

Comparing two lists in Calc is a routine operation in any spreadsheetSurely 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 will be able to do them without any problem.

Step 1

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 you want compare and go to format which 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.

Step 2

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 It 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”.

Step 3

Now go to the tab “Background” and then choose a background color so that cells with the same value are highlighted, and then click “OK”. The next thing you will have to 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 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 that COUNTIF ($ B $ 3: $ B $ 30; E3)> = 1. And voila, if you correctly followed the aforementioned steps, you will have the result you expected.