| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Best way to subtotal this data?
Hello all,
I have a worksheet with a bunch of data that I need to extract certain statistics from. I need to show the total number of hours charged by each person to each group they worked in for the last year. So, I need to sort by person, then by group, then by total number of hours in each. Each person may or may not have any hours in any given group. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data/Subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Subtotal when using XML data | Excel Discussion (Misc queries) | |||
| Using more than one subtotal with same data set | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
