function

W

Waleed

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
 
T

T. Valko

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

=LOOKUP(1E100,B2:B100)

Adjust the range to suit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inequalities Function 3
IF function says too many nested 1
I have either a H or A in cell B5. 2
Payment calculation 1
IF function 1
Lookup Function help 1
how to get totals? 1
Return text not excel address 2

Top