How do I always insert last cell from a increasing array ?

[Radu]

In a increasing array of values I want to use always the last value as input
in another formula. Is there a smart trick? Thanks

[Bob Phillips]

=INDEX(A:A,MATCH(9.99999999999999E307,A:A))

will get the last value in column A.

--

HTH

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


"Radu" <Radu@discussions.microsoft.com> wrote in message
news:B32DB923-CACE-47CC-A3CC-12166779BCF9@microsoft.com...
> In a increasing array of values I want to use always the last value as
input
> in another formula. Is there a smart trick? Thanks