Thread: collapsing rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default collapsing rows

On Dec 5, 1:44 pm, Jim S. wrote:
I am looking to do this as a formula. I have a column of dates with earnings
associated with these dates in the next column. Some of the dates are within
the same month and I need to sum the earnings for each month and put into
another column without having a blank row.




I think a macro here would be your best friend. Assign it to a
control box or a hot key.

Pierre