Hi,
If I have numbers in column B

B2 5
B3 6
B4 7
B5 8
B6 empty
B7 empty
B8 empty
I need a function to return a value of last cell which have number before
the empty cell, I mean cell B5, and the returned number showed in cell C4, .
If I add number to cell B5 return a value of cell B6, and so on.
Thank for help in advaance