Returns a range starting from a specified cell and ending at the last cell of the corresponding table. Used for dynamic tables.

Syntax

=MM_TABLE(Cell)

• Cell
  Starting cell of the range the function returns.

Remarks

• 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.

• Warning: in Excel, it may have a different behavior. If the row (or the column) corresponding to Cell contains an empty cell on the right of Cell (below Cell), the function returns a different range as it does not recognize tables. To be more precise, the range ends at the last non empty cell (for both columns and rows). Empty cells have no impact in Mind. See the second example.

• See MM_COLUMN and MM_ROW if you want to return a column range or a row range.

Example 1: Basic example

Formula1: =SUM(MM_TABLE(A2)) returns 986. Indeed, MM_TABLE(A2) returns the range A2:C7. Thus, what is calculated is the sum of all values in the table. 

Formula2: =SUM(MM_TABLE(B2)) returns 632. Indeed, MM_TABLE(B2) returns the range B2:C7. Thus, what is calculated is the sum of all values of the last two columns of the table.

Example 2: Different behavior in Excel

Let us replace two values by empty cells. In that case, headers were added so that Mind understands how the table is defined. Otherwise, the table would stop at the cell which contains the value 41. 

Formula3: =SUM(MM_TABLE(A3))
In Mind, the function returns 905, which is the sum of all remaining values.
In Excel, the function returns 216. Indeed, in Excel, MM_TABLE(A3) returns A3:A5.