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

Try this:

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

HTH,

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


"DSS" wrote in message
...
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

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" wrote in message
...
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