Hello guys,

I was trying to count the number of unique values in a range, with using the following formula:

=SUMPRODUCT(1/COUNTIF(A1:A447148,A1:A447148))
however, it seems this formula is not working on a large list since I got 447,148 values in my list,
the formula just return to 0 after it takes a minute to calculate the value.
So is there are anyway to count the number of distinct value in a list ?

Thank you.