Compare names in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
do a vlookup on col b usin values in col a
whereever there is N/A# those are unique in col A
 
Back
Top