Quote:
Originally Posted by mmatz
I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the
different instances. So in this example it would be 3 because bbb is
repeated. Is there a formula that does this?
|
Try:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
where A1:A10 contain your data to count.