function
 

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

function
 

This will return the *last* numeric value in the range:

=LOOKUP(1E100,B2:B100)

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"Waleed" wrote in message
...
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