Let's say that the array you want to check is in column B. Put this into
another column besides B. This SHOULD give you the value of the last
entered cell in Column B.
=CELL("contents",INDIRECT(ADDRESS(MATCH(9.99999999 999999E+307,B:B),2)))
Let's say I learned something here today. Thanks!
If you want another column besides row B, you'll have to change the very
last 2 to match the column # (a=1, b=2, c=3, d=4, etc)
"pateodoro" wrote:
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.
|