In an adjacent column, add this formula

=COUNTIF($A$1:A2,A2)1

and copy down

Then filter that column for the TRUE value, and delete visible rows.

--

HTH

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


"Ctech" wrote in
message ...

Hi

Hi have a list of names, however some is duplicated. Is there a easy
way to delete all the duplicates.. some are also duplicated more than
once...

Thanks


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=486784