Well thanks for this, it has opened up the whole new concept of array
formulas for me. As a novice, however, I seem to be doing something
wrong.
I have carried out the follwing steps;

Entered a number of values in column A
Entered the formula in Cell B1 and pressed CTRL-SHIFT-ENTER
I then get message saying that the formula contains an error
The part of the formula A65535"" is highlighted (I found it would
accept the formula without these two quotation marks - but of course it
does not return the right value)

Is it possible to tell from this what I am doing wrong?

Thanks in advance.

JE McGimpsey Wrote:
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=INDEX(A:A,MAX((A1:A65535"")*ROW(INDIRECT("1:65535 "))))


In article ,
dthomas wrote:
-
Is it possible to link a cell to a column in such a way that the cell
will always return the last value in that column, and will update
when
a new value is added to the column?

Thanks-


--
dthomas