How to find last value entered and than find the value before it and than substarct

[damx]

Hi all,


I would like to ask for your help with finding a formula that would
find the last value entered , than subtract from it the value before.
So (see the attached pic) the formula i need should identify 10 as the last value,
than identify 7 as the last value before 10 and do 10-7 .
The values will not be introduced at regular intervals.

excel.png

[Pete_UK]

Put this in A13:

=LOOKUP(10E10,A1:A12)-LOOKUP(10E10,INDEX(A1,1):INDEX(A1:A12,MATCH(LOOKUP(10E10,A1:A12),A1:A12,0)-1))

Hope this helps.

Pete

[damx]

Hi ,

Wasn't expecting such fast reply so thanks Pete.
Still I think I didn't expressed my self correctly in the first post. I'm not looking necessarily for "10" but for the first cell containing any value counting upwards and than for the next one.