Solved: Copy the last cell at the same collum

luizaziz · 02-14-2020 11:09 AM

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

Steve

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:

View solution in original post

Steve

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"
)