copy days total to other worksheet
 

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

copy days total to other worksheet
 

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.

hsg;246902 Wrote:
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
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68899