Home |
Search |
Today's Posts |
#1
|
|||
|
|||
outline & groups
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 | |
|
|
Similar Threads | ||||
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) |