G Guest Jun 20, 2007 #1 Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a subtotal?
D Dave Peterson Jun 20, 2007 #2 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.
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.
G Guest Jun 20, 2007 #3 Yes, considered that...without the use of another field/indicator...just looking for a quick function on raw data. Any more ideas?
Yes, considered that...without the use of another field/indicator...just looking for a quick function on raw data. Any more ideas?
D Dave Peterson Jun 20, 2007 #4 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? Click to expand...
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? Click to expand...
