S savbci Jul 23, 2008 #1 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?
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 Jul 23, 2008 #2 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.
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 Jul 23, 2008 #3 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.
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.
