How do I count or display unique data in a column?

[kbeilers]

I want to display all the unique names in a column, but I can't find a
"unique" command. I also want to be able to count all the unique names in
the column.

Ideas?

 

[Peo Sjoblom]

A couple of ways, the easiest would be to use advanced filter,
data>filter>advanced filter, select unique records only and preferably copy
to another location,

then use a simple counta

=COUNTA(Range)

(deduct 1 for the header)

if you filter in place use subtotal

=SUBTOTAL(3,Range)

or you could use an array formula, cannot be entered in the first row since
it uses
the same column and the row above where it's first entered

=INDEX(Range,MATCH(0,COUNTIF($I$1:I1,Range),0))

is how it would look if it is entered in cell I2, enter it with
ctrl + shift & enter and copy down until you get an error

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)