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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
How do I use sumif and mid function in same formula 2
refer to range in another sheet 5
Cell offset issue 3
Copy down a range of formulae 6
SORT data containing formula 5
How to extract a character from a string then VLOOKUP a table? 7
Average of Subtotals in Pivot Table 0

Back
Top