Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting by week w/sub totals
I would like to separate a list of order by week with a sub total for
that week. I pretty new to excel and would appicate any help. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting by week w/sub totals
If you have a column which contains week number, then you can sort the
data by that column. Then you could apply Data | Subtotals and work through the wizard, setting it up to give you a subtotal for each change of week number. Hope this helps. Pete On Feb 27, 3:11*am, wrote: I would like to separate a list of order by week with a sub total for that week. I pretty new to excel and would appicate any help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
sorting data by time and day of week | Excel Worksheet Functions | |||
Sorting Dates in Days of the Week | Excel Discussion (Misc queries) | |||
sorting/ordering a column by day of the week | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |