counting unique values
Posted by steven on December 28, 2001 4:06 AM
Hello,
I have a range of numbers, say from a1 to a100. I would like to have a formula wich counts the unique numbers in this range
ex.
1002
1005
1008
1002
1005
number of unique numbers = 3
thanks, steven