Sorting and Adding Space
 

My spreadsheet is downloaded as:

006 02 $1.00
006 02 $1.00
006 03 $1.00
006 03 $1.00
007 02 $1.00
007 02 $1.00
007 03 $1.00
007 03 $1.00
What I need to do is put a space in between the changes in column 2 and sum,
end result:

006 02 $1.00
006 02 $1.00
(02 Sum of 006) $2.00
006 03 $1.00
006 03 $1.00
(03 Sum of 006) $2.00
007 02 $1.00
007 02 $1.00
(02 Sumof 007) $2.00
ETC.......
How do I have it insert the row at the changes in Column 2 and sum in the
last row?

Sorting and Adding Space
 

On Wed, 16 Nov 2005 07:22:03 -0800, "Stewart"
wrote:

My spreadsheet is downloaded as:

006 02 $1.00
006 02 $1.00
006 03 $1.00
006 03 $1.00
007 02 $1.00
007 02 $1.00
007 03 $1.00
007 03 $1.00
What I need to do is put a space in between the changes in column 2 and sum,
end result:

006 02 $1.00
006 02 $1.00
(02 Sum of 006) $2.00
006 03 $1.00
006 03 $1.00
(03 Sum of 006) $2.00
007 02 $1.00
007 02 $1.00
(02 Sumof 007) $2.00
ETC.......
How do I have it insert the row at the changes in Column 2 and sum in the
last row?

Take a look at the Data/Subtotal and Data/Pivot Table wizards. One of them
should be able to give you a report that will accomplish what you want.
--ron

Sorting and Adding Space
 

Select your data range, then DataSubtotals (from the main menu)..experiment
with the settings until you get what you want.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Stewart" wrote:

My spreadsheet is downloaded as:

006 02 $1.00
006 02 $1.00
006 03 $1.00
006 03 $1.00
007 02 $1.00
007 02 $1.00
007 03 $1.00
007 03 $1.00
What I need to do is put a space in between the changes in column 2 and sum,
end result:

006 02 $1.00
006 02 $1.00
(02 Sum of 006) $2.00
006 03 $1.00
006 03 $1.00
(03 Sum of 006) $2.00
007 02 $1.00
007 02 $1.00
(02 Sumof 007) $2.00
ETC.......
How do I have it insert the row at the changes in Column 2 and sum in the
last row?