Subtotal Range of Alphanumeric References
 

Hi, I am looking for a formula that counts the number of occurrances in
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?


--
girthhart
------------------------------------------------------------------------
girthhart's Profile: http://www.excelforum.com/member.php...fo&userid=9409
View this thread: http://www.excelforum.com/showthread...hreadid=506303

Subtotal Range of Alphanumeric References
 

Try...

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

Hope this helps!

In article ,
girthhart
wrote:

Hi, I am looking for a formula that counts the number of occurrances in
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?

Subtotal Range of Alphanumeric References
 

Hallelujah! It works, thanks Domenic.


--
girthhart
------------------------------------------------------------------------
girthhart's Profile: http://www.excelforum.com/member.php...fo&userid=9409
View this thread: http://www.excelforum.com/showthread...hreadid=506303