| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double Subtotal Problem {Excel 2000}
I am trying to subtotal "at each change in" column 1 and then I do a new subtotal "at each change in" column 2 and uncheck "replace current subtotals" if there are 10 or more rows everything is fine. If there are less than 9 rows, the "Summary below data" rows are switched on the last subtotal. Is this a known bug or just something that I have yet to figure out?
Correct (10 rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE SOFT MAPLE 15/16" Grand Grand Incorrect (9 original rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE Grand Grand |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Double Subtotal Problem {Excel 2000}
Sure there isn't a difference in your last entry - such as an additional space at the end.
-- Regards, Tom Ogilvy PGibson wrote in message ... I am trying to subtotal "at each change in" column 1 and then I do a new subtotal "at each change in" column 2 and uncheck "replace current subtotals" if there are 10 or more rows everything is fine. If there are less than 9 rows, the "Summary below data" rows are switched on the last subtotal. Is this a known bug or just something that I have yet to figure out? Correct (10 rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE SOFT MAPLE 15/16" Grand Grand Incorrect (9 original rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE Grand Grand |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Double Subtotal Problem {Excel 2000}
nope... This macro starts by importing a .csv file and I removed a detail row from the middle to be sure not to mess with the last record. Puzzling!
"Tom Ogilvy" wrote in message ... Sure there isn't a difference in your last entry - such as an additional space at the end. -- Regards, Tom Ogilvy PGibson wrote in message ... I am trying to subtotal "at each change in" column 1 and then I do a new subtotal "at each change in" column 2 and uncheck "replace current subtotals" if there are 10 or more rows everything is fine. If there are less than 9 rows, the "Summary below data" rows are switched on the last subtotal. Is this a known bug or just something that I have yet to figure out? Correct (10 rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE SOFT MAPLE 15/16" Grand Grand Incorrect (9 original rows): Species STGSort POPLAR 4/4 FAS POPLAR RED OAK 15/16" 4/4 1C SOU RED OAK 15/16" 4/4 2C RED OAK 15/16" 4/4 FAS RED RED OAK 15/16" 4/4 FAS SOU RED OAK 15/16" SOFT MAPLE 15/16" 4/4 FAS RED SOFT MAPLE 15/16" 4/4 FAS SOU SOFT MAPLE 15/16" SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE Grand Grand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double Pivot Table - Match Subtotal Rows | Excel Discussion (Misc queries) | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
| Excel Subtotal problem | Excel Worksheet Functions | |||
| Cannot Double Click to open Excel 2000 documents | Excel Discussion (Misc queries) | |||
| double line spacing using excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
