ExcelBanter - Unique Value Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Unique Value Formula (https://www.excelbanter.com/excel-programming/435133-unique-value-formula.html)

Phil H[_2_]

Unique Value Formula

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

Jacob Skaria

Unique Value Formula

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

If this post helps click Yes
---------------
Jacob Skaria

"Phil H" wrote:

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

Don Guillett

Unique Value Formula

http://office.microsoft.com/en-us/ex...561181033.aspx

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Phil H[_2_]

Unique Value Formula

Thanks, Jacob. Works fine.

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria

"Phil H" wrote:

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

All times are GMT +1. The time now is 01:57 AM.