I have two long columns of data in LibreOffice Calc, something like below:

```
Jimmy | Jimmy
Bunk | Bunk
Lester | Lester
Prez | Prez
...
```

These columns are most likely identical, that is, they contain exactly the same entries. However it is possible that for some reason they are not, for example if one of the columns was re-ordered. I want to compare them to see if they are indeed identical.

How do I compare two columns (or two rows) in Calc and see if they are exactly the same?

## Best Answer

Suppose

`Jimmy`

is in cellsA1andB1. In cellC3use function`EXACT`

, so the formula of cellC3will be:Apply the same formula for every cell in column

C. In Calc you can grab the little black square in the cell and drag it, so the same formula is applied for multiple cells, but the cells of columnAandBare changed accordingly.Column

Cnow shows`TRUE`

if and only if cells in corresponding columns to the left are both identical.Then for every value of column

Capply function`AND`

. For example if there are 100 entries in columnC, your cell would look like:The last cell shows

`TRUE`

if and only if all cells in columnCare`TRUE`

.If there's a simpler method to compare two columns or two rows in Calc, don't hesitate to post it as an answer.