Duplication in Column

[Ket]

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

 

[Peo Sjoblom]

Tag them


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

 

[Bob Phillips]

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)