Comparing two columns of words to find out missing

Hello Experts,
I have two columns ( almost 1900 cells each ) with almost identical words. I wish to compare one list to another an find out only missing.
I have tried =isna(match(A1, $B$1:$b$2000),0)) gives one true/false; ideally missing name should appear...
Any suggestions?
Thanks

If you have TRUE, that means that the word in A1 has an exact match in column B somewhere. If it is FALSE, then the word in A1 is not present in column B. There is no need for the word to appear, as it is the word in A1.

Copy the formula down to get a series of TRUEs and FALSEs. Apply a filter to that column to select FALSE, and the visible words in column A are the words for which there is no match in column B. You could copy these to another sheet if you wanted the full list.

Hope this helps.

Pete

Pete,
Thanks for assistance, is my formula/syntax wrong? I am getting false even though both words appear to be ditto?
=ISNA(MATCH($B$2:$B$291,C2,0))
see below
Col B Col C
corporate christmas party ideas corporate christmas party ideas FALSE

Thanks
Karnik

Yes, the syntax is wrong. The first parameter should be the cell that you are trying to find a match for, the second parameter is the range you want to look in, so you seem to have got these the wrong way round:

=ISNA(MATCH(C2,$B$2:$B$291,0))

looks to see if there is a match between C2 and any cell in the range B2:B291. It's confusing because you have used ISNA, so a TRUE result actually means there is no match. It would be better to write it like this:

=ISNUMBER(MATCH(C2,$B$2:$B$291,0))

so that a TRUE result means there IS a match and a FALSE result means there isn't.

Hope this helps.

Pete

P.S. No need for PM - contributors to a thread automatically get email notifications.

Thank Pete,
I appreciate your timely guidance...
cheers
Karnik