How do I create a formula in Excel that finds the value of the la.

B

BerlinUSA

I am needing assitance in finding a formula that allows me to find the value
of the last nonblank cell in a range.
 
N

N Harkawat

=INDEX(A1:A10,MATCH(FALSE,ISBLANK(A1:A10),0))
array entered (ctrl+shift+enter)

However if your values are always number then this should do
=LOOKUP(999999999999999,A:A)
assuming the looked up value is in column A
 
R

Ron Rosenfeld

I am needing assitance in finding a formula that allows me to find the value
of the last nonblank cell in a range.
Click to expand...

=LOOKUP(2,1/(1-ISBLANK(rng)),rng)

Note that "rng" cannot be more than 65,535 cells (so a full column reference
like A:A will not work). If it might be, post back for another solution.


--ron
 
Top