On 2002-04-22 08:07, ksmithcpa wrote:
I need a formula to count the number of unique records in a column. For example:
100
200
300
100
400
100
This column contains 4 unique records. Any ideas are appriciated.
On 2002-04-22 08:09, Mark W. wrote:
=COUNT(IF(FREQUENCY(A:A,A:A),1))
...where your values are listed in column A.
On 2002-04-22 11:27, ksmithcpa wrote:
When I try this formula with my original example I get 9, when what I want is 4. I did have to modify the formula a little to get excel to accept it.
=count(if(frequency(A:A,A:A),1,0)
Am I missing something?
On 2002-04-22 08:09, Mark W. wrote:
=COUNT(IF(FREQUENCY(A:A,A:A),1))
...where your values are listed in column A.