Forum Discussion
Helping comparing two sheets for missing data
Hello All, I am trying to compare two spreadsheets to find which values on Spreadsheet A are missing fro Spreadsheet B. Spreadsheet A--> 24k rows and my original dataset. Spreadsheet B--> 56k Ro...
Let's say the CD Number is in column C on Spreadsheet A and in column D on Spreadsheet B, starting in row 2.
In an empty column on Spreadsheet A. enter the text Not in B (or similar) in row 1.
In row 2, enter the following formula, change Spreadsheet B to the real name of that sheet, then fill down:
=ISERROR(MATCH(C2, 'Spreadsheet B'!$D$2:$D$60000, 0))
This formula will return TRUE if the CD Number in column C does not occur on Spreadsheet B, FALSE if it does occur.
You can now filter the new column for TRUE.