Hello,

When would you use the Grouping function in order to obtain subtotals
instead of using the Subtotals function?

Thank you.

You probably wouldn't.

But, since it's common to use <data<subtotals to summarize large data
lists, it's a handy feature to be able to expand/collapse the details (via
Grouping)

However, there are valid reasons to use only Grouping without subtotals. For
example, to provide an easy mechanism to show/hide parts of reports for
printing or presentation.

I hope that helps.
Post back if you have more questions

***********
Regards,
Ron

XL2003, WinXP


"Helen" wrote:

Hello,

When would you use the Grouping function in order to obtain subtotals
instead of using the Subtotals function?

Thank you.

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

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