Hi!
Assume your list is in the range A1:A100
Count of uniques:
=SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&""))
I would also like to know the number of times each value appears in the
column.
One way to do this:
Use DataAdvanced Filter to copy unique values to another location. Assume
that new location is B1:B10. In C1 enter this formula and copy down to C10:
=COUNTIF(A$1:A$100,B1)
Biff
"coolkid397" wrote
in message ...
Is there any way to find the number of unique values among a set of
values in a column in an excel sheet. I would also like to know the
number of times each value appears in the column.
Thanks
--
coolkid397
------------------------------------------------------------------------
coolkid397's Profile:
http://www.excelforum.com/member.php...o&userid=24319
View this thread: http://www.excelforum.com/showthread...hreadid=379248