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

[Guest]

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?

 

[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)

 

[Gord Dibben]

Data>Filter>Advanced Filter.

Check "unique records only" and "copy to another location".

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP

 

[Guest]

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


Regards,

Peo Sjoblom