Excel subtotal group sort
 

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.

I'm not sure what internal and external subtotals are, but maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

rick@bcbsne wrote:

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.

--

Dave Peterson

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

"Dave Peterson" wrote:

I'm not sure what internal and external subtotals are, but maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

rick@bcbsne wrote:

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.

--

Dave Peterson

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

"rick@bcbsne" wrote:

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

"Dave Peterson" wrote:

I'm not sure what internal and external subtotals are, but maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

rick@bcbsne wrote:

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.

--

Dave Peterson

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

Glad you found the post.

MaryK wrote:

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

"rick@bcbsne" wrote:

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

"Dave Peterson" wrote:

I'm not sure what internal and external subtotals are, but maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

rick@bcbsne wrote:

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.

--

Dave Peterson


--

Dave Peterson