Thread: How do I always insert last cell from a increasing array ?
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default How do I always insert last cell from a increasing array ?
=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" wrote in message
...
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


Reply With QuoteReply With Quote