Forum Discussion
Comparing worksheets based on multiple columns to determine differences
I am looking to determine if there is built in functionality to quickly see the differences between two different spreadsheets. Use Case: I have two separate systems that are supposed to have th...
I was hoping that excel would have native tools where you could say in worksheet 1, combination of columns 1 and 2 (and 3 and 4 if needed) provide a unique identifier - perhaps it would tell you how many you needed to pick for unique values. You would select the equivalent columns of data in the second worksheet, and the result would be to identify all of the rows that are in both sheets, and also output the unique rows in each sheet as well as any that were unable to determined due to duplicate "unique values"
I am afraid if you upload your workbooks more talent will join the discussion as below.
https://techcommunity.microsoft.com/t5/excel/highlight-duplicates-in-sheets-with-2-criteria/m-p/3983132#M211456
https://techcommunity.microsoft.com/t5/excel/highlight-duplicates-in-sheets-with-2-criteria/m-p/3983132#M211456