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

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

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

One way...

Sheet1
A1 = John
B1 = Smith

Sheet2
A1 = Smith, John

On Sheet1 C1 enter this formula:

=IF(ISNUMBER(MATCH(B1&", "&A1,Sheet2!A1:A10,0)),"Dup","")

--
Biff
Microsoft Excel MVP


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

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