Duplication in Column

  • Thread starter Thread starter Ket
  • Start date Start date
K

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
 
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)
 
Back
Top