Re: delete both duplicates

From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
Date: Wed, 23 Jul 2008 09:46:30 -0500

I'd insert a formula in the adjacent column:

=countif(a:a,a1)
and drag down
Then filter to show the values greater than 1 and delete those visible rows.

savbci wrote:

I don't have easy filter. how do i delete both duplicates?
ie.
apple
pear
apple
grape

i want only pear and grape to appear?

--

Dave Peterson
.

Prev by Date: Re: Removing text
Next by Date: RE: Inserting a checkable box (checks when clicked) into Excel?
Previous by thread: RE: delete both duplicates
Next by thread: Inserting a checkable box (checks when clicked) into Excel?
Index(es):
- Date
- Thread

Relevant Pages

Re: Array to single row -- Any simple way to do this?
... > array of multiple rows and columns into one row of values which have ... > 1 Apple ... Pear ... > 2 Grape ...
(microsoft.public.excel.misc)
RE: delete both duplicates
... run a pivot table on that column, which will give you a unique list of ... i want only pear and grape to appear? ...
(microsoft.public.excel.misc)
Re: Accessing the values of HoH
... jelly -- strawberry ...
(perl.beginners)
Re: machine figure
... A pear, a plum, a grape, apple. ...
(rec.puzzles)
Re: Double hires mode color artifacts
... expect of an Apple II, given its resolution and color limitations. ... essentially no change after the window had filled with 14 "dots". ... pixel on host pixel boundaries. ... A filter of 4 bit width in hires should be already sufficent for that. ...
(comp.sys.apple2)