Comparing two lists of Name

B

Bull

Can someone point me in the right direction? What is the best way to
take two lists of same last names, sheet 1 and sheet 2, and on sheet 3
it tells you which names on sheet 1 are not on sheet 2?

Need to figure out what names are missing on sheet 2.

Thanks
 
P

Peter T

One way,

Assuming the lists are in Col-A on both sheets, and that in Sheet1 starts in
A1

In a helper column on Sheet1
=MATCH(A1,Sheet2!A:A,0)

Copy down and you should see #N/A where not matched, ie a missing name.

Or, literally to show which names are missing
=IF(ISERROR(MATCH(A1,Sheet2!A:A,0)),A1,"")

Regards,
Peter T
 
Top