Identify Unique entries in a list

N

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
 
J

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
 
J

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
 
Top