Finding duplicate names

[Guest]

Okay, I got a list of people's names. Column A are first names. Column B is last names. In colum C I need a formula that will put the word duplicate if the last names and first names are the same. This is the formual that I think can be modified, but I'm not sure how to modify it

=IF(COUNTIF(Range1,???)>1,"Duplicate","Not a Duplicate"

This is kind of what I want
Column A Column B Column
Jen Black Not a duplicat
Jack Black Not a duplicat
Jen white Duplicat
Jen white Duplicat

 

[Dave Peterson]

I'd use a helper column and check that:

=a1&"..."&b1

Then drag down.

 

[Max]

Try this ..

Assuming the data in cols A and B are in row1 down

Put in C1: =TRIM(A1&" "&B1)

Put in D1:

=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Not a Duplicate")

Select C11 and copy down

For the sample data in your post
C14 will now contain:

Jen Black....Not a Duplicate
Jack Black..Not a Duplicate
Jen white.....Not a Duplicate
Jen white.....Duplicate

Think the first occurence of "Jen white" should rightly tag as
"Not a Duplicate" instead of "Duplicate"
(as indicated in your post)

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

Okay, I got a list of people's names. Column A are first names. Column B

is last names. In colum C I need a formula that will put the word duplicate
if the last names and first names are the same. This is the formual that I
think can be modified, but I'm not sure how to modify it:

 

[Guest]

Thanks. That worked great!
--
Matt in AZ

Try this ..

Assuming the data in cols A and B are in row1 down

Put in C1: =TRIM(A1&" "&B1)

Put in D1:

=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Not a Duplicate")

Select C11 and copy down

For the sample data in your post
C14 will now contain:

Jen Black....Not a Duplicate
Jack Black..Not a Duplicate
Jen white.....Not a Duplicate
Jen white.....Duplicate

Think the first occurence of "Jen white" should rightly tag as
"Not a Duplicate" instead of "Duplicate"
(as indicated in your post)

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

is last names. In colum C I need a formula that will put the word duplicate
if the last names and first names are the same. This is the formual that I
think can be modified, but I'm not sure how to modify it:

 

[Max]

Pleasure' Matt !