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 [email protected],
> dthomas [email protected] 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
Bookmarks