just the reverse
=IF(ISNA(VLOOKUP(B1 & ", " & A1,Sheet1!A:A,1,0)),"","Duplicate")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

and with error handling....
=IF(ISNA(VLOOKUP(A1 & ", " & B1,Sheet1!A:A,1,0)),"","Duplicate")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Suppose in sheet1 you have the combined version

In sheet 2 in cell C1 try the below which will combine the entries and
lookup in sheet1 for a match...

=VLOOKUP(B1 & ", " & A1,Sheet1!A:A,1,0)

If this post helps click Yes
---------------
Jacob Skaria


"KFM" wrote:

I have two spreadsheets that contain duplicate names of idividuals. One
spreadsheet includes the first name in column "A" and the last name in column
"B". The other spreadsheet contains the entire first and last name in column
"A" in the format; "Lastname, Firstname".

Is there a way for me to identify (not eliminate) these duplicates even
though they are not identical?

Thanks,
KFM