Unfortunalely your answer did not help me... :-(

That formula resulted in lots of erros which I could not repair...

"Max" wrote:

One way is to try JE's array formula
to a recent similar query: http://tinyurl.com/8gysf
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"pateodoro" wrote in message
...
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.