Manikandan Arunachalam
Manikandan Arunachalam

Reputation: 1500

Compare/check multiple columns in multiple sheets and find the unmatched values

I have two sheets in libreoffice calc, both sheets have same columns, i need to compare these sheets column values(multiple columns) and need to check rows are equal, if not equal then need to differentiate the unmatched values.

How can i do this?Please help me to get this done.

Upvotes: 0

Views: 243

Answers (1)

tohuwawohu
tohuwawohu

Reputation: 13618

Maybe the easiest way is to put the sheets in different ods files and use the built-in document comparison feature to compare both: Menu Edit -> Compare Documents....

Upvotes: 1

Related Questions