T
Tiffany
Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
subtotal?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
If you have an indicator in each row that identifies the group, you can sort by
that indicator and then use data|subtotals to get the subtotals.
Depending on what you're doing, you may find using a pivottable
(data|pivottable) (still requiring that indicator field) may be easier and
quicker.
that indicator and then use data|subtotals to get the subtotals.
Depending on what you're doing, you may find using a pivottable
(data|pivottable) (still requiring that indicator field) may be easier and
quicker.
T
Tiffany
Yes, considered that...without the use of another field/indicator...just
looking for a quick function on raw data. Any more ideas?
looking for a quick function on raw data. Any more ideas?
D
Dave Peterson
Nope. Adding the indicator field is where I'd start.
Yes, considered that...without the use of another field/indicator...just
looking for a quick function on raw data. Any more ideas?