copy days total to other worksheet

[hsg]

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

 

[JBeaucaire]

Try this. Put the first date in cell A1 on Sheet2, then this formula in
B1:

=VLOOKUP(A1,Sheet1!A1:C100,3,TRUE)

Does that work for you? The "true" is the magic. Setting it to TRUE
causes the VLOOKUP to find the last matching value, setting it to FALSE
will find the first.