Identify Unique entries in a list

[Neil Bhandar]

Hello:

I have a column with 24K entires I need a derive a short
list of unique entires?

Is there an easy way of doing this?

I am currently doing this with a Macro (Sort data and
bubble search) and it takes tooo long.

Any help is appreciated,
-Neil

 

[Jason Morin]

Try this in row 1:

=COUNTIF($A$1:A1,A1)=1

and copy down. Then sort descending for this column.

HTH
Jason
Atlanta, GA

 

[Aladin Akyurek]

See various methods described in

http://makeashorterlink.com/?P55021C06

in particular, revised Method 1.

 

[Joe Gieder]

Have you tried creating a pivot table? I use them all the
time to consolidate Bills Of Materials and they work for
me.

Joe