Is there a quick way to delete all duplicate rows in a column?

J

Jellaby

Column A consists of names; Column B consists of dates. If a name is
registered on more than one occasion, there will be two entries with same
name, different dates. Is there a quick way to delete these duplicates other
than sorting Col. A alphabetically and deleting them manually?
 
B

Bob Phillips

In C1 add

=IF(COUNTIF($A$1:A1,A1)>1,"Dup","")

and copy down

then filter on column C, and select Dup, and delete visible rows

--

HTH

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

Peo Sjoblom

Data>adavnced filter, copy to another location and unique records only


Regards,

Peo Sjoblom
 
Top