Helping comparing two sheets for missing data

[destiner09]

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 Rows

I have tried all sorts of formulas and nothing seems to be working out without needing to do 7 steps every time, I am hoping there is an easier way to make this happen. 

Both datasets have a Column Header "CD Number". I have tried Vlookup around this but the result only returns data points that are missing a CD number, which is correct, BUT I know there are also CD numbers contained in A, that were NOT included in B, but when I do the VLOOKUP they do not show. Any suggestions for me would be great! Thank you!

[#2]

@destiner09 

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.