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

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?

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)


"Jellaby" wrote in message
...
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?

DataFilterAdvanced 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

On Mon, 16 May 2005 13:53:01 -0700, "Jellaby"
wrote:

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?

Dataadavnced filter, copy to another location and unique records only


Regards,

Peo Sjoblom

"Jellaby" wrote:

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?