Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function...random search? | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |