ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   data subtotalling isnt working properly on my spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/66142-data-subtotalling-isnt-working-properly-my-spreadsheet.html)

robert

data subtotalling isnt working properly on my spreadsheet
 
i have a spreadsheet that i am trying to data subtotal down to 3 levels, but
when I create the 2nd level for grouping (data, subtotal) it calls itself the
1st level, ie it appears above the grand total and therefore doesnt display
correctly. Everything looks to be sorted correctly. Any help appreciated
Robert

Dave Peterson

data subtotalling isnt working properly on my spreadsheet
 
Maybe...

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

robert wrote:

i have a spreadsheet that i am trying to data subtotal down to 3 levels, but
when I create the 2nd level for grouping (data, subtotal) it calls itself the
1st level, ie it appears above the grand total and therefore doesnt display
correctly. Everything looks to be sorted correctly. Any help appreciated
Robert


--

Dave Peterson


All times are GMT +1. The time now is 05:26 AM.

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