Excel Function

[Guest]

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!
==============================================


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

 

[Guest]

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