RE: delete both duplicates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: M Kan <tipsoftheweek at gmail dot com>
Date: Wed, 23 Jul 2008 07:45:01 -0700

Are you just trying to create a unique list of items? One easy way is the
run a pivot table on that column, which will give you a unique list of
values, which you can copy and paste somewhere else.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"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?

Prev by Date: RE: Unprotect workbook
Next by Date: Inserting a checkable box (checks when clicked) into Excel?
Previous by thread: RE: Unprotect workbook
Next by thread: Re: delete both duplicates
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: Accessing the values of HoH
... jelly -- strawberry ...
(perl.beginners)
Re: machine figure
... A pear, a plum, a grape, apple. ...
(rec.puzzles)
Re: delete both duplicates
... Then filter to show the values greater than 1 and delete those visible rows. ... i want only pear and grape to appear? ...
(microsoft.public.excel.misc)
Re: opinions on logical OR variation
... However, presumably a product cannot be both an apple and an orange, ... #define PEAR 3 ... #define PLUM 4 ... > void do_something ...
(comp.lang.c)