Subtotal Range of Alphanumeric References

  • Thread starter Thread starter girthhart
  • Start date Start date
G

girthhart

Hi, I am looking for a formula that counts the number of occurrances i
a range of alphanumeric references, my range looks like this:

1 A B C
2 A6
3 A6
4 B2
5 B2
6 B2
7 T3
8 T3
9 T4
10 F3

Although there are 9 references, there are only 5 of each type
therefore the formula would return 5.

Anyone help
 
Back
Top