Double Subtotal Problem {Excel 2000}

P

PGibson

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
 
T

Tom Ogilvy

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
 
P

PGibson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal GroupBy text string 2
Help!! find two number recurring numbers in row?? 1
Subtotal Formatting 2
Maximum value as well as Sum 1
.SubTotal: Controlling where the caption goes? 0
Combining Multiple Rows of Data in Excel 4
Excel Subtotals 2
Insert row above subtotal 3

Top