The formula below counts the number of unique numeric and text values in a column:

=SUMPRODUCT((J1:J100<>"")/COUNTIF(J1:J100,J1:J100&""))

Kevin

=SUMPRODUCT((J1:J100<>"")/

Kevin