Hello,

I have a column of names in the format FirstName LastName.
The column contains many thousands of rows of data.

What is the best way to find out what names have been duplicated in
the list?

Thanks in advance for your assistance.

Regards,
Ket
London

Tag them


http://www.cpearson.com/excel/duplicat.htm

--

Regards,

Peo Sjoblom


"Ket" wrote in message
...
Hello,

I have a column of names in the format FirstName LastName.
The column contains many thousands of rows of data.

What is the best way to find out what names have been duplicated in
the list?

Thanks in advance for your assistance.

Regards,
Ket
London

In an adjacent column, add

=IF(COUNTIF(A:A,A1)1,"Duplicate","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ket" wrote in message
...
Hello,

I have a column of names in the format FirstName LastName.
The column contains many thousands of rows of data.

What is the best way to find out what names have been duplicated in
the list?

Thanks in advance for your assistance.

Regards,
Ket
London