| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I think this is difficult - can it be done?
Hi All,
Sorry for the vague header but l couldn't figure out a sutiable title. I would like to know if there is a way to do this: T1.25 L2.00 T0.25 -------- 3.00 Total of column ignoring letter prefixes If it makes it easier the prefixes could be suffixes instead. Spaces or characters such as : # could be used to seperate the letters from the figures. This is required for a 'Resource Planner' that l am developing that is required to span as many days as possible accross the columns so using a helper column is not a practical option. Additionally l would like to apply group sub-totals (preferably using data/subtotals) and still have the column summed ignoring the letters. Has anyone got any ideas please? TIA Regards Michael Beckinsale |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difficult | Excel Programming | |||
| Help, too difficult for me. | Excel Worksheet Functions | |||
| Difficult but do-able? | Excel Discussion (Misc queries) | |||
| Is this difficult??? | Excel Programming | |||
| Ok I have to be difficult | Excel Programming | |||
Threaded Mode
