Identify Unique entries in a list

  • Thread starter Thread starter Neil Bhandar
  • Start date Start date
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
 
Try this in row 1:

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

and copy down. Then sort descending for this column.

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

Joe
 
Back
Top