Compare names in two columns

[Guest]

Hi

I have two columns A and B. All the names in column B are in A but A also
has extra names. How can I compare the two columns and bring back just the
names that are in Col A only.

Thanks in advance

 

[Nitin Harkawat]

do a vlookup on col b usin values in col a
whereever there is N/A# those are unique in col A

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther