Count the number of unique Values in a column

[O177812]

Hi, I am trying to count the number of unique values in a column:

When I use this: =SUMPRODUCT(1/COUNTIF(I2:I103,I2:I103))
It works perfectly.

The only issue is that the total number of rows is dynamic and when tried this: =SUMPRODUCT(1/COUNTIF("I2:I"&MAX((I:I<>"")*(ROW(I:I))),"I2:I"&MAX((I:I<>"")*(ROW(I:I)))))

I received an error

This formula: MAX((I:I<>"")*(ROW(I:BI))) returns the correct value of "103" I just don't know how to insert it into my initial formula.

Any help would be greatly appreciated.

 

[DRSteele]

You could try the snappy function UNIQUE combined with COUNT.

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(I2:I10000,I2:I10000<>"")))

 

[O177812]

How about

=ROWS(UNIQUE(FILTER(I2:I10000,I2:I10000<>"")))

THIS WORKED!!!!! THANK YOU!!!!

 

[Fluff]

You're welcome & thanks for the feedback.