I have two excel sheets with the similar header columns and dataset is similar however some times there are some miss-match with their values which I would like to compare with excel formulas or lookup or built in tool. Please advise
compare two excel worksheet
84 Views Asked by user3750136 At
2
There are 2 best solutions below
0
On
If you are just looking to compare two spreadsheets, Windows comes with a function called Spreadsheet Compare. Just do a search in the task bar and it should come up. It is great if you are looking to compare two separate workbooks. If they are in the same workbook you can copy one into a new workbook then compare them. It will show every discrepancy.
On Sheet1 you can place in column D (example is for row 2 to highlight the row with a mismatch) the following formula:
This will output TRUE or FALSE depending if the email matches for the unique id. You can adapt using this either for a more complex formula or for conditional formatting.