Iโd like to copy the last cell at the same collum to โInitial Valueโ
Solved! Go to Solution.
Try:
LOOKUP(
MAXROW(
"table-name",
"_ROWNUMBER",
([_THISROW].[_ROWNUMBER] > [_ROWNUMBER])
),
"table-name",
"key-column",
"column-name"
)
replacing table-name
with the name of the table, key-column
with the name of that tableโs key column, and column-name
with the name of the column containing the desired value.
The above gets the value from the row before the one youโre working with, which may not be the last row of the worksheet if youโre editing an existing row. The below always gets the value from the last row (not including the one youโre editing):
LOOKUP(
MAX(
table-name[_ROWNUMBER]
- LIST([_ROWNUMBER])
),
"table-name",
"_ROWNUMBER",
"column-name"
)
See also:
Try:
LOOKUP(
MAXROW(
"table-name",
"_ROWNUMBER",
([_THISROW].[_ROWNUMBER] > [_ROWNUMBER])
),
"table-name",
"key-column",
"column-name"
)
replacing table-name
with the name of the table, key-column
with the name of that tableโs key column, and column-name
with the name of the column containing the desired value.
The above gets the value from the row before the one youโre working with, which may not be the last row of the worksheet if youโre editing an existing row. The below always gets the value from the last row (not including the one youโre editing):
LOOKUP(
MAX(
table-name[_ROWNUMBER]
- LIST([_ROWNUMBER])
),
"table-name",
"_ROWNUMBER",
"column-name"
)
See also:
Itยดs worked !!!
Thanks a lot
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |