Unique Value Formula

[Phil H]

In cell range A10:A250, count the number of unique values, and ignor blanks
(errors). What is the formula?

 

[Jacob Skaria]

Try
=SUMPRODUCT((A10:A250<>"")/COUNTIF(A10:A250,A10:A250&""))

If this post helps click Yes

 

[Don Guillett]

http://office.microsoft.com/en-us/excel/HP030561181033.aspx

 

[Phil H]

Thanks, Jacob. Works fine.

Try
=SUMPRODUCT((A10:A250<>"")/COUNTIF(A10:A250,A10:A250&""))

If this post helps click Yes