Hi

Try:

=SUM(1/COUNTIF(Range,Range))

Enter it as an array by pressing Shift+Ctrl+Enter

or

=SUMPRODUCT(1/COUNTIF(Range,Range))

Range is just the range where your items are.


--
Cheers,
Shane Devenshire


"uncmello" wrote:

I need the total number of unique values in a list. I don't what to know how
many of each value there is.
Here's an example
33071
33071
33071
33072
33683
33912
33912
33912
33953
34250
In this case I need the answer to be 6
I also would like it to update the answer when I change the filter. Is that
possible?