Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Gentlemen,
Thank you both for your replies. This is what I was looking for. Cheers, Helene "Dave Peterson" wrote: I would think that if you have a key column that can be used for categorizing each group, then data|subtotal makes more sense. If there is no unique identifier (per group) available, then I'd be stuck using Data|Group. (Really, I'd find a way to add a helper column and add a unique identifier per group.) Helen wrote: Hello, When would you use the Grouping function in order to obtain subtotals instead of using the Subtotals function? Thank you. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotals in Excel 2003 with Autofilter and Grouping | Excel Discussion (Misc queries) | |||
Subtotals in Excel 2003 with Autofilter and Grouping | Excel Discussion (Misc queries) | |||
Subtotals by grouping | Excel Worksheet Functions | |||
What's the difference between 2000 and 2003 when using subtotals? | Excel Worksheet Functions | |||
Pivot Table Subtotals - Difference | Excel Worksheet Functions |