Resizes and populates the table in which the function is contained to fit a specified grid. Useful to replace an array formula whose size varies depending on some parameters (you do not need to define beforehand an array formula that fits the result of your function). 

Syntax

=MM_RANGE(VirtualGrid)

• VirtualGrid
  The grid used to resize and populate the table in which the MM_RANGE function is contained. 

Remarks

• This function is not meant to be used inside another function. It must be used alone in a single cell table. See example.

• If VirtualGrid has a fixed size, MM_RANGE is not necessary. You can get the same result by using an array formula on a range that has the same size as VirtualGrid.

• The result of this function is only seen in Mind, not in Excel.

Example 1: With a function returning a grid

We want to calculate the inverse of a matrix, knowing that the size of the matrix can vary depending on the inputs you import. 

The formula: 

= MM_RANGE(MINVERSE(MM_TABLE(A2)))

must be contained in a table without any other formulas or inputs as shown below.

Note that the formula MM_TABLE(A2) returns the entire range contained in the table #Matrix. Here it returns a 2 by 2 matrix. 

The main formula resizes the table #Result and returns the results of the function inside MM_RANGE, thus the inverse of the 2 by 2 matrix. You can see below in the second table the inverse of the initial matrix.

Now, let us import some data in the table #Matrix: the initial matrix becomes a 3 by 3 matrix. You will then get in #Result the corresponding inverse matrix, which is a 3 by 3 table too.

Example 2: With custom formula

The MM_RANGE function can be really useful to return the result of a custom formula. To learn more about custom formulas, check the linked article. 

Indeed, if your custom formula returns a grid whose size depends on your inputs for instance, you cannot define an array formula to fit the result of your custom formula directly in Excel.

Instead, you can call your custom formula inside the MM_RANGE function. It is similar to the previous example, except the specified function is not an Excel function but a custom formula. 

=MM_RANGE(MyCustomFormula(Param1, Param2,[...]))