Count the number of different characters in a range

Hi,

In a column I have a list with different characters in an order I don't know.
How can I find out how many different characters I have?
In the attached example the result should be 3 (There are A's, B's and C's. But no D's, no E's and so on).

Thanks for your help,
alexandre

Hi,

You can use the COUNTIF function

=COUNTIF(A1:A15,"A")

Try:

=SUMPRODUCT((A1:A15<>"")/COUNTIF(A1:A15,A1:A15&""))

Thanks a lot!
Works perfectly

Is it possible to distinguish capital letters from small letters?

Originally Posted by aderougemont

Is it possible to distinguish capital letters from small letters?

Try:

Please Login or Register  to view this content.

This is an array formula and must be confirmed with CTRL+SHIFT+ENTER not just ENTER.. you will see { } brackets appear around the formula..

P.S.

Next time you should add a new post to the thread instead of editing it, especially after the original question was solved... we don't always look back at solved threads...and you may think you are being ignored... or post a new thread with a new question.