MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count function for unique values in a cell


Posted by scot on December 14, 2001 3:22 PM

What function do I need to use to count the number of unique occurrences in a row of cells?

For example in column A I have the following values:

1
1
2
2
2

I want to know how many different values are in this row of numbers. The answer should return 2. What function do I need?


Posted by Mark W. on December 14, 2001 3:38 PM

=COUNT(IF(FREQUENCY(A:A,A:A),1))

...the only caveat... this will only work for
numeric values.