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