ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display the last value of an array (https://www.excelbanter.com/excel-worksheet-functions/29711-display-last-value-array.html)

pateodoro

Display the last value of an array
 
How can I display in a cell the last value of an array that is continuously
being updated? For example, I have the array A1:A8 with the following values
A1 5
A2 10
A3 16
A4 20
A5
A6
A7
A8
I would like to display the last value I have. In this case the last value
is "20". But when "A5" is filled in with "30" then I would like that it would
appear "30".
Thank you!



All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com