Comparing two lists of Name
 

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

Comparing two lists of Name
 

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


"Bull" wrote in message
...
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