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
Sure there isn't a difference in your last entry - such as an additional space at the end.
--
Regards,
Tom Ogilvy
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
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!
Sure there isn't a difference in your last entry - such as an additional space at the end.
--
Regards,
Tom Ogilvy
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
