Count unique if text
T. Valko wrote...
This will account for both formula blanks ("") and empty cells (array
entered):
=SUM(N(FREQUENCY(IF((ISTEXT(B1:B20))*(B1:B20<"") ,MATCH(B1:B20&"",B1:B20&"",0)),
MATCH(B1:B20&"",B1:B20&"",0))0))
Or one could use
=SUMPRODUCT(ISTEXT(rng)*(rng<"")/COUNTIF(rng,rng&""))
as long as none of the values in rng contained wildcard characters *
and ? or began with =, <, , <, <= or =.
|