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

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

=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



"BerlinUSA" <BerlinUSA@discussions.microsoft.com> wrote in message
news:A885AF78-1A71-4299-915A-090775A24513@microsoft.com...
>I am needing assitance in finding a formula that allows me to find the
>value
> of the last nonblank cell in a range.

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

--

HTH

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


"BerlinUSA" <BerlinUSA@discussions.microsoft.com> wrote in message
news:A885AF78-1A71-4299-915A-090775A24513@microsoft.com...
> I am needing assitance in finding a formula that allows me to find the
value
> of the last nonblank cell in a range.

On Fri, 15 Apr 2005 13:36:04 -0700, BerlinUSA
<BerlinUSA@discussions.microsoft.com> wrote:

>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