Excel subtotal group sort

R

rick@bcbsne

When nested subtotals are created for sorted groups, the inside subtotal
appears before the external subtotal as expected until the inside group only
has one value. At this point the external subtotal displays before the
internal for the remainder of the spreadsheet. An example can be supplied if
necessary.
 
R

rick@bcbsne

Thanks Dave! That fixed the problem even though it seems completely
unnecessary.
 
M

MaryK

Thanks from me, too, Dave! I spent a couple of hours trying to figure this
out last night!
 
D

Dave Peterson

And then you found out it was a bug in excel. (I hate that!)

Glad you found the post.
 
Top