Copy the last cell at the same collum

I’d like to copy the last cell at the same collum to “Initial Value”

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:





2 Likes

It´s worked !!!
Thanks a lot

1 Like