How do I always insert last cell from a increasing array ?
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 |
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 |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com