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 |
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 |
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 |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com