View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stewart
 
Posts: n/a
Default 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?