| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal duplicate
I have a list of amounts that are attached to 3 separate elements. I need to
have a subtotal on a single line (no levels like in the 'subtotal' function) for each change in the 3 columns as a whole, then delete the lines that are not total lines. I need to work this into an existing macro, but I record all of them & the subtotal function with 3 levels got way too messy. The list is always a variable length & all 3 columns will have different values. Any suggestions? Original list: A B C D GL ST RL AMT 602600 01 KC 30.00 602600 01 KC 4.50 602600 00 GA 10.00 602600 00 GA 2.25 602600 04 KB 15.00 602600 04 KB 3.75 702600 04 KB 6.00 602600 04 KE 24.00 602600 04 KE 4.50 602600 04 KM 7.50 List as I would like it to be: GL ST RL AMT 602600 01 KC 34.50 602600 00 GA 12.25 602600 04 KB 18.75 702600 04 KB 6.00 602600 04 KE 28.50 602600 04 KM 7.50 Any help would be appreciated! -- DanaK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotal duplicate
Data Pivot Table and Pivot Chart.
Place Gl andf RL in the 'Rows' area. Place AMT int the 'Data Items' area. Finally, double-click GL Subtotals None. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "DanaK" wrote: I have a list of amounts that are attached to 3 separate elements. I need to have a subtotal on a single line (no levels like in the 'subtotal' function) for each change in the 3 columns as a whole, then delete the lines that are not total lines. I need to work this into an existing macro, but I record all of them & the subtotal function with 3 levels got way too messy. The list is always a variable length & all 3 columns will have different values. Any suggestions? Original list: A B C D GL ST RL AMT 602600 01 KC 30.00 602600 01 KC 4.50 602600 00 GA 10.00 602600 00 GA 2.25 602600 04 KB 15.00 602600 04 KB 3.75 702600 04 KB 6.00 602600 04 KE 24.00 602600 04 KE 4.50 602600 04 KM 7.50 List as I would like it to be: GL ST RL AMT 602600 01 KC 34.50 602600 00 GA 12.25 602600 04 KB 18.75 702600 04 KB 6.00 602600 04 KE 28.50 602600 04 KM 7.50 Any help would be appreciated! -- DanaK |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotal duplicate
Thank you, Ryan, but I've tried a pivot table & it won't work in this
instance. I need a clean list of subtotals to be used 8 different ways in the same macro. And ever since I got MS 2007, I've had trouble using pivot tables. One of the areas I wish they had not changed! DanaK "DanaK" wrote: I have a list of amounts that are attached to 3 separate elements. I need to have a subtotal on a single line (no levels like in the 'subtotal' function) for each change in the 3 columns as a whole, then delete the lines that are not total lines. I need to work this into an existing macro, but I record all of them & the subtotal function with 3 levels got way too messy. The list is always a variable length & all 3 columns will have different values. Any suggestions? Original list: A B C D GL ST RL AMT 602600 01 KC 30.00 602600 01 KC 4.50 602600 00 GA 10.00 602600 00 GA 2.25 602600 04 KB 15.00 602600 04 KB 3.75 702600 04 KB 6.00 602600 04 KE 24.00 602600 04 KE 4.50 602600 04 KM 7.50 List as I would like it to be: GL ST RL AMT 602600 01 KC 34.50 602600 00 GA 12.25 602600 04 KB 18.75 702600 04 KB 6.00 602600 04 KE 28.50 602600 04 KM 7.50 Any help would be appreciated! -- DanaK |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotal duplicate
Maybe this would work:
Data Subtotals At each change in RL and Add Subtotal to AMT. Then, click OK. Then, you can group the data or leave it ungrouped. Good luck, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "DanaK" wrote: Thank you, Ryan, but I've tried a pivot table & it won't work in this instance. I need a clean list of subtotals to be used 8 different ways in the same macro. And ever since I got MS 2007, I've had trouble using pivot tables. One of the areas I wish they had not changed! DanaK "DanaK" wrote: I have a list of amounts that are attached to 3 separate elements. I need to have a subtotal on a single line (no levels like in the 'subtotal' function) for each change in the 3 columns as a whole, then delete the lines that are not total lines. I need to work this into an existing macro, but I record all of them & the subtotal function with 3 levels got way too messy. The list is always a variable length & all 3 columns will have different values. Any suggestions? Original list: A B C D GL ST RL AMT 602600 01 KC 30.00 602600 01 KC 4.50 602600 00 GA 10.00 602600 00 GA 2.25 602600 04 KB 15.00 602600 04 KB 3.75 702600 04 KB 6.00 602600 04 KE 24.00 602600 04 KE 4.50 602600 04 KM 7.50 List as I would like it to be: GL ST RL AMT 602600 01 KC 34.50 602600 00 GA 12.25 602600 04 KB 18.75 702600 04 KB 6.00 602600 04 KE 28.50 602600 04 KM 7.50 Any help would be appreciated! -- DanaK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
| subtotal by week with duplicate dates? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| subtotal of identical data and deleting its duplicate | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Hybrid Mode
