Finding duplicate names

Thanks. That worked great!
--
Matt in AZ


"Max" wrote:

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 atyahoodotcom
----
"Matt in AZ" wrote in message
...
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 C
Jen Black Not a duplicate
Jack Black Not a duplicate
Jen white Duplicate
Jen white Duplicate

Pleasure' Matt !

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"Matt in AZ" wrote in message
...
Thanks. That worked great!
--
Matt in AZ