Sorting and Adding Space

S

Stewart

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?
 
R

Ron Rosenfeld

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?
Click to expand...

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
 
R

Ron Coderre

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

Does that help?

••••••••••
Regards,
Ron
 
Top