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?