Auto subtotal every 100 rows
 

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
--
TASR

Auto subtotal every 100 rows
 

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.

Tiffany wrote:

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
--
TASR

--

Dave Peterson

Auto subtotal every 100 rows
 

Yes, considered that...without the use of another field/indicator...just
looking for a quick function on raw data. Any more ideas?


--
TASR


"Dave Peterson" wrote:

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.

Tiffany wrote:

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
--
TASR

--

Dave Peterson

Auto subtotal every 100 rows
 

Nope. Adding the indicator field is where I'd start.

Tiffany wrote:

Yes, considered that...without the use of another field/indicator...just
looking for a quick function on raw data. Any more ideas?

--
TASR

"Dave Peterson" wrote:

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.

Tiffany wrote:

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
--
TASR

--

Dave Peterson


--

Dave Peterson