ExcelBanter - Link to last entry

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Link to last entry (https://www.excelbanter.com/new-users-excel/29418-link-last-entry.html)

dthomas

Link to last entry

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

JE McGimpsey

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

=INDEX(A:A,MAX((A1:A65535<"")*ROW(INDIRECT("1:655 35"))))

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

All times are GMT +1. The time now is 04:26 PM.