Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My data has following pattern
A B C 1-2-2009 5 5 1-2-2009 8 13 1-2-2009 3 16 2-2-2009 5 5 2-2-2009 7 12 3-2-2009 3 3 3-2-2009 and so on. B column contains some data, and 'C' column, contains progressive sum of cells above it, such that on row1, c1=b1, in row2 c2=c1+b2 and c3=c2+b3 and so on. The last row which contains 1-2-2009, contains final total for 1-2-2009. Row 4 again starts over for new date like c4=b4, then c5=c4+b5. Is it possible to pick only final totals form column C and paste them in separate worksheet in a manner that only final totals will come in that sheet one below other, with date, and no intervening cell totals should come. pl help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working out total Numbers of Days | Excel Discussion (Misc queries) | |||
How do I copy sub total data only onto a new worksheet? | Excel Discussion (Misc queries) | |||
Formating Total Number of Days | Excel Worksheet Functions | |||
Total number of days between 2 dates | New Users to Excel | |||
Total last 30 days | Excel Worksheet Functions |