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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display multicolumn box 6
display multicolumn box 1
=Trend question 1
AdvancedFilter syntax 2
Inaccurate count with code 6
Count unique values in one column if values in corresponding columnare null? 1
find cell location of max value in column 6
filter column unique for alphanumeric 3

Back
Top