compare two columns of data

[Jeanne]

I have two columns of data, A & B. Column A has numbers
in it that column B does not. I need to identify what
number are in A that are not in B. I have tried vlookup
but it does not seem to work correctly & also the countif
function. Each column is in sequential order with no
spacing if a number is missing. I do not know what I am
doing wrong and would appreciate any help.

 

[Trevor Shuttleworth]

Jeanne

put the following formula in a cell on row 1 and then drag down to the end
of your list:

=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),A1&" not found", "")

Regards

Trevor

 

[Guest]

Bravo! You have save me so much hard work. Thanks a ton!

 

[Ashish Mathur]

Hi,

Try the following in C5 (aray enter the formula - Ctrl+Shift+Enter):

IF(OR(EXACT(A5,$B$5:$B$8))=TRUE,A5,"")

Hope this helps

Regards,

Ashish Mathur

 

[Trevor Shuttleworth]

You are very welcome.

Bravo! You have save me so much hard work. Thanks a ton!