Excel Duplicates Count Once (counting different letters)
Hello,
In A1:A10 I have :
( A,A,A,A,B,B,C ) (only 7 values, the rest is blank but it can have letters too if I want)
I want to count the amount of different letters I have in this area minus the last letter.
So, in this case I know that the result would be 1-A and 1-B, the C doesn't count. The last letter is summed apart of this formula that I want.
If I have ( A,B,B,B,B,A ) , The first A will not count because it exists in as final letter.
So, I just want to count if a letter appears more than once beside s of being final letter. If it appears more than once, then its counting is only 1.
What I want : "to find if the last letter is equal to some other letter, and if so, don't count it, and then count the amount of different letters"
In the first example the result would be = 2 ( 1A + 1B ; C is unique, so does not count)
In the second example the result would be = 2 ( 1A + 1B ; Last A does not count because there are more than 1A)
Is it possible a formula to find this and show the result in one cell?