This function is used to calculate dynamic functions from the add-in, for instance, MM_FILTER, MM_REMOVEDUPLICATES, MM_HUNION, MM_VUNION, ...etc. It appears automatically on adjacent cells if you use one of these functions. 

We call dynamic functions, functions that are automatically resized in Excel and in Mind using the MM_GETRANGE function (and not the built-in array formulas in Excel from Office 365).

It has no other purpose than to calculate the results of such functions on adjacent cells. This function is not meant to be directly used by the user.

Syntax

This section is for information only. 

This function should only be used by the system and is not meant to be used directly by the user.

=MM_GETRANGE(Cell,Cell2)

• Cell
  Target cell where the range is stored. This refers to the cell where the dynamic function is defined.
• Cell2
  Target cell where the range is stored. Cell2 is always equal to Cell.

Remark

• By checking the presence of this function, you can quickly identify if one Mind function is a dynamic function or not. This is particularly useful if you want to determine if the function needs to use additional resize flags to be resized. Indeed, dynamic functions are, by definition, automatically resized.

Example

The function MM_REMOVEDUPLICATES is a dynamic function. In the case below, we want to have in the grid '#Dynamic function' the values of the grid '#Input' without duplicates. The function is defined with the following formula on cell C3 (selected cell):

The result is the following: