How To Compare Two Lists Or Columns In Calc Libreoffice Easily

 smiling man answers the phone lthough PC with stairs are blurry back - plane

Office documents are one of the most used worldwide programs because they meet one of the most basic functions, it is possible to create text documents. One in particular is LibreOffice is one of the open document files programs drives source more powerful and easy to use; and best of all it’s free download.

There is a specific program called Calc is the version of Excel LibreOffice tools you might find useful. One of them is going to show you this – below which easily compare two lists or columns with Calc. Although tience also some cool features like Configure and print two pages per sheet .

I do not know how to compare the two lists or columns in Calc? You’re not alone so do not worry if you do not know and we will help. We will guide you through the process you have to do compare two lists in Calc easily and quickly a simple procedure.

What is LibreOffice?


LibreOffice programs and logos package

I do not know LibreOffice? If you do not know do not worry, we’ll tell you LibreOffice and what advantages compared to other programs of this style. So you know and understand more information you provide, as they issue from a broader perspective.

LibreOffice is an open source software developed by The Document Foundation for Windows operating systems , MacOS and Linux. This first began as a diffraction and was subsequently acquired by Sum Microsystems in August 1999.

These programs differ from others because being open source, you can find them for free that can help you even more tools and extensions find and delete duplicates . Today we’ll talk about Calc and how to compare the two lists or columns, so if you do not have download to your PC to follow our steps.

How to compare two lists or columns in Calc easily?


 spreadsheet and graphics in different LibreOffice

To compare two lists in Calc is a routine operation sheet , surely the reason you want to learn how to do in Calc. The procedure is very simple just follow the steps you give and you can do it without any problems.

Step 1

First, go to the spreadsheet you want to compare and open to begin the process. Then click the cell of one of the columns compare and see the format that is in the main menu.

Then go to ” conditional formatting” , and ” condition” and the area that you select appears Condition 1 to “Formula is”.   then you must enter the comparison formula to write the following, you need to first CONTAR.SI


Step 2

Now hooks must place the values ​​of the second column which is compared to the first so ($ E $ 3: $ E $ 30; B3) & gt; = 1 . In Example appreciate can $ E $ 3: $ E $ 30 includes values ​​of the second column of the first box to the last box where tendras text if that were the case


And we also B3 & gt; = 1 representing the second box, this formula means that if the range E3: E30 appears in cell B3 should return the value “ real “. It only remains to add the highlighted and this you must deploy ” apply Style” and click “New Style”.

Step 3

Now go to the “Fund” and select a background color to highlight cells with the same value and click “OK”.   The next thing you need to do is to extend these formulas to other cells and for this you need only go to the Brush tool selected cell 1.

Then just drag the brush on the other cells you and therefore the value you put in the cell 1 were compared with the range of cells 2. Then simply repeat these steps for the two listed companies with the only difference that the formula of the two would be something like CONTAR.SI ($ B $ 3: $ B $ 30; E3) & gt; = 1 loan if you have followed the above steps correctly can have the result you expected.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

Deja un comentario