Excel funtion to create a unique list of entries ?

  • Thread starter Thread starter Neil Bhandar
  • Start date Start date
N

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
 
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
 
Back
Top