delete both duplicates

  • Thread starter Thread starter savbci
  • Start date Start date
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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to add numbers in a text string 5
Populate Data In Rows 9
Copy & Paste Non Blanks Only 2
Array to single row -- Any simple way to do this? 4
HELP WITH A FORMULA 1
Index/match across multiple columns? 19
Create tabs named after a group of cells? 3
Quickie on Pivots 4

Back
Top