Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing automatic link | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Link Link Link | Setting up and Configuration of Excel | |||
Breaking the link | New Users to Excel | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |