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

[Guest]

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

 

[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

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.LastValue.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[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.

=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