delete both duplicates
 

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?

delete both duplicates
 

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?

delete both duplicates
 

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