ExcelBanter - Counting unique text/number cells from a range

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

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

- - Counting unique text/number cells from a range (https://www.excelbanter.com/excel-programming/331808-counting-unique-text-number-cells-range.html)

sudeepd12

Counting unique text/number cells from a range

Please consider a long range of text cells containing A, B, C, D....
and more.

Lets say it goes from H1 to H1500

A -H1
A
B
F
D
A
H
D

Bob Phillips[_6_]

Counting unique text/number cells from a range

=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"sudeepd12" wrote
in message ...

Please consider a long range of text cells containing A, B, C, D....Z
and more.

Lets say it goes from H1 to H1500

A -H1
A
B
F
D
A
H
D

All times are GMT +1. The time now is 10:56 PM.