Excel Function

[DSS]

how do I write a formula in Excel that returns the last value in a column of
figures? This column grow in length as numbers are added daily

[RagDyer]

Try this:

=LOOKUP(9.99999999999999E+307,A:A)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"DSS" <DSS@discussions.microsoft.com> wrote in message
news:E2EE77C5-9507-401F-9014-89FFD051C917@microsoft.com...
how do I write a formula in Excel that returns the last value in a column of
figures? This column grow in length as numbers are added daily

[ww]

try this:
=OFFSET(A1,count(A:A)-1,0)
You can change this formula until it returns the right result.

"RagDyer" wrote:

> Try this:
>
> =LOOKUP(9.99999999999999E+307,A:A)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "DSS" <DSS@discussions.microsoft.com> wrote in message
> news:E2EE77C5-9507-401F-9014-89FFD051C917@microsoft.com...
> how do I write a formula in Excel that returns the last value in a column of
> figures? This column grow in length as numbers are added daily
>
>