Excel funtion to create a unique list of entries ?

[Neil Bhandar]

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

 

[JMay]

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

 

[Neil Bhandar]

Thanks you very very much.

Range("A:A").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Columns("Z:Z"), Unique:=True

you saved me over 2 hours to stupid code run time.
Thanks,
-Neil