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?