Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet with data that contains the following headers:
Year Dollars Vendor Invoice # and Vendor Name I want to group each year information in to a Group and have a subtotal of that year and be able to do it for all five years that I have, how do I do this with Outline and Group functions. Thanks Gustavo |
#2
![]() |
|||
|
|||
![]()
One way;
DataSortYear with header row DataSubtotalsAt each change in YearSum Dollars HTH "G Gustavo" wrote: I have a worksheet with data that contains the following headers: Year Dollars Vendor Invoice # and Vendor Name I want to group each year information in to a Group and have a subtotal of that year and be able to do it for all five years that I have, how do I do this with Outline and Group functions. Thanks Gustavo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet protection and "Group and Outline" | Excel Discussion (Misc queries) | |||
Protection with Outline | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Protect sheet with outline | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |