Compare names in two columns

J

Jo

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
 
N

Nitin Harkawat

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