| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal: Totals line output
When I run a subtotal I would like the results to include other headings:
In the following example I would like the total line to include the part number. Desired Output: Op PartNumber Up Hrs Good Scrap 01 Total F789 1.75 519 68 02 Total F1615 22.88 1123 32 Actual Output Example: Op PartNumber Up Hrs Good Scrap 01 F789 0.87 251 60 01 F789 0.88 268 8 01 Total 1.75 519 68 (Actual Totals Line) 02 F1615 8.00 361 15 02 F1615 6.88 354 6 02 F1615 8.00 408 11 02 Total 22.88 1123 32 (Actual Totals Line) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I subtotal my weekly totals by months? | Excel Worksheet Functions | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| Subtotal line selection | Excel Discussion (Misc queries) | |||
| How do I copy Summary totals only from a subtotal list? | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
Linear Mode
