delete both duplicates

S

savbci

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

M Kan

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.
 
D

Dave Peterson

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.
 
Top