Conditionally Minus Result

[Stephen_IV]

I have an issue. What I am trying to is to minus the last 2 results in a column. As you can see below. We do attendance daily. What I would like to do is minus the last to figures greater than 0. In the case below it will be =B5-A5 for the next day it will be =C5-B5 Etc. Can someone please help me with a formula. Thanks in advance Stephen.<

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	1	2	3	7	8	9	10	11	14	15	16	17	18	21	22	23
2	9	11
3	10	11
4	7	12
5	26	34	0	0	0	0	0	0	0	0	0	0	0	0	0	0		8
Sheet1

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	1	2	3	7	8	9	10	11	14	15	16	17	18	21	22	23
2	9	11	11
3	10	11	10
4	7	12	14
5	26	34	35	0	0	0	0	0	0	0	0	0	0	0	0	0		1
Sheet2

 

[Expiry]

Is this not as simple as typing =B5-A5 in cell B6 and then copying this across row 6?

 

[Aladin Akyurek]

Stephen,

Channge the SUM formula in A5 to:

=IF(COUNT(A2:A4),SUM(A2:A4),"")

Define BigNum as referring to:

=9.99999999999999E+307

Then invoke for substraction:

=LOOKUP(BigNum,A5:P5)-LOOKUP(BigNum,INDEX(A5:P5,MATCH(BigNum,A5:P5)-1))

 

[Andrew Poulsom]

Similarly:

=INDEX(A5:P5,1,MATCH(9.99999999999999E+307,A2:P2))-INDEX(A5:P5,1,MATCH(9.99999999999999E+307,A2:P2)-1)

 

[Stephen_IV]

Aladin Akyurek, Andrew Poulsom,

Thank you so much. Worked perfectly!

 

[Andrew Poulsom]

Andrew Poulsom,

Thank you so much. Worked perfectly!

Except, of course, in month 1.