Unique Value Formula

  • Thread starter Thread starter Phil H
  • Start date Start date
P

Phil H

In cell range A10:A250, count the number of unique values, and ignor blanks
(errors). What is the formula?
 
Try
=SUMPRODUCT((A10:A250<>"")/COUNTIF(A10:A250,A10:A250&""))

If this post helps click Yes
 
Back
Top