Look on the toolbar at Data, Filter Advanced - Unique records.


"Neil Bhandar" wrote in message
...
Hello:

I have a column with over 24K entries (tons of
duplicates), I need to arrive at a unique list of entires.
I am currently sorting the data and then doing a bubble
search (typical), the process is very slow.

Can some one suggest a function that could give me a
unique list quickly?

Seems only reasonable since Excel sorts and stores sucha
unique list in memory when you filter the column.

Any help is appreciated,
-Neil