| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC..
I wanted know how can I make a letter ie A or B represent a number, in this
case I wanted all characters represent 0.5. This is to add them all up. At the end I wanted to collectively sum up how many As, Bs etc.. in numbers: Mon Tues Wed A=1 B=0.5 etc... J G A B H C N S A --------------------------- 1.5 1.5 1.5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a letter represent a number? | Excel Worksheet Functions | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| Staff rota, how can I make a letter represent a shift? | Excel Discussion (Misc queries) | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| How do I get a letter to represent a number for scheduling? | Excel Worksheet Functions | |||
Threaded Mode
