A counting formula that won't count multiple instances of same val
I need a formula that will count all the different instances of a value in a
column. For example, in the example below, the count would be 3 because, "1,"
though it occurs thrice, will only be counted once.
Col A
1
1
2
3
1
Thanks in advance,
Howard
|