Returns the cell in the same row as the specified cell and in the last column of the corresponding table. Used for dynamic tables.

Syntax

=MM_LASTCOLUMNCELL(Cell)

• Cell
  Cell that defines the table and the row for the output.

Remarks

• Warning: This formula has a different behavior in Excel and in Mind. See the first example.

• This function is useful when you have dynamic tables, i.e. when the size of your table varies, for instance, if you use the input manager, interlinks, or dynamic instances. 

• See MM_LASTROWCELL to return the cell in the same column as the specified cell and in the last row of the corresponding table.

Example 1: Direct call to the cell

Formula1: =MM_LASTCOLUMNCELL(B3) returns 93 in Mind. Indeed, the function refers to the cell for the last column of the grid and the third row.
In Excel, the function returns 11 because the first empty cell of the table is in column C. Thus, it returns the value before, which corresponds to B3. 

Exemple 2: As a cell reference

You can use the MM_LASTCOLUMNCELL function as a reference inside a function.

Formula2: =SUM(B3:MM_LASTCOLUMNCELL(B4)) returns 278. Indeed, MM_LASTCOLUMNCELL(B4) refers to cell D4. Thus, the formula is summing the first two rows of the table.