Find nearest number in column and subtract

[ManateeProfanity]

Hi,

I'm trying to take B26 'END' and subtract from the closest number above it in the column, this would be dynamic and could be B17 or B25. This would number would end up in 'B35' Home. Any ideas? Cheers



Capture.JPG

[Pete_UK]

Wouldn't it always be the last time that you entered in B15:B25 if they are in sequence? If so, you could use this formula in B35:

=B$26 - LOOKUP(100,B$15:B$25)

Hope this helps.

Pete

[ManateeProfanity]

Legend, thanks mate