count different instances in a list
mmatz,
Assuming that your list is in cells A1:A5, if you put this formula in A7, it
should accomplish what you desi
=countif(A1:A5,"bbb")
HTH,
Conan
"mmatz" wrote in message
...
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?
|