Excel funtion to create a unique list of entries ?
 

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

Excel funtion to create a unique list of entries ?
 

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

Excel funtion to create a unique list of entries ?
 

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

-----Original Message-----
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


.