Unique Value Formula

P

Phil H

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

Jacob Skaria

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

Calculate the median value before a specified list 0
Autonumber field in Excel that behaves the same as Access 0
Transfer data between two tables 3
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Newbie Help - IF Yes No Function 0
Inaccurate count with code 6
filter column unique for alphanumeric 6
Copy addition formula of non-consecutive horizontal cells 2

Top