Forum Discussion
How to compare 2 excel sheets with an Unique identifier?
Hi! How do I compare values in sheet 1 and sheet 2, and display it on sheet3? Example: Sheet 1 has the following columns: ID Age Address Sheet 2 has the following columns: Age of bit...
You may try free CompareSheets (without space) add-in from Microsoft Store, it has also a built in algorithm that identifies the unique identifiers, as well has an option you can exclude from comparison (but not from output) columns that you do not want to track, will show what was changed in the rows and columns