ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   subtotal in a list (https://www.excelbanter.com/excel-discussion-misc-queries/109274-subtotal-list.html)

afi

subtotal in a list
 
Is nested subtotals possible within a list in Excel?

Debra Dalgleish

subtotal in a list
 
If this is an Excel 2003 List, you can convert the list to a range, then
use the Subtotal command.
After you apply one subtotal, choose the Subtotal command again.
Select the next subtotal settings, and remove the check mark from
'Replace current subtotals'

afi wrote:
Is nested subtotals possible within a list in Excel?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 05:09 PM.

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