ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotal issues (https://www.excelbanter.com/excel-discussion-misc-queries/149435-subtotal-issues.html)

simmerdown

Subtotal issues
 
I have a spreadsheet with a list of Carriers and Clients......insurance terms.

When I subtotal first on Carrier, then by Client, without replacing the
first subtotal, it places the subtotal for Client BELOW the subtotal for
Carrier.

Does anyone know the reason why this is happening and the fix for it?

Thank you.

Dave Peterson

Subtotal issues
 
Maybe...

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

simmerdown wrote:

I have a spreadsheet with a list of Carriers and Clients......insurance terms.

When I subtotal first on Carrier, then by Client, without replacing the
first subtotal, it places the subtotal for Client BELOW the subtotal for
Carrier.

Does anyone know the reason why this is happening and the fix for it?

Thank you.


--

Dave Peterson


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com