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? E.g. I have the array A1:A8 as follows:
A1 5
A2 10
A3 16
A4 20
A5
A6
A7
A8
As in the example, the last value of the array is 20. But when I fill in
the cell A5 with 35, I would like that it would appear that number. Thank you
for your help.
|