Compare data in two excel sheets

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find the difference.

Ideally both the sheets must have same data, as they are extracted running same queries from two servers (old & New (post data migration))

Now the data in the new sheet might have some additional data which is not present in the old sheet and also some data might be missing in the new sheet as compare to the old sheet.

Kindly help me on this. Aniticipating an early response.

Thanks,
Anil

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
one way would be to combine all columns into single column and then do a column compare