MM_SORTRANGE sorts a target multidimensional range.

Syntax

=MM_SORTRANGE(Obj, SortingOrderObj,[Name, Index],[Name2, Index2],..)

• Obj: Range on which you want to perform sorting.

• SortingOrderObj: Sorting order: True=ascending, False= descending

• Name: Name of your dimension loop (optional)

• Index: Index of your loop (optional)

 Warning: The parameter LoopName is case sensitive.

Remarks

• This function is similar to function MM_SORT, as it can also sort ranges. New functions MM_SORTDIM and MM_SORTRANGE are just different versions from the use of MM_SORT.

• See MM_RANK function to return the rank of the sorted values of the dimensions of the input cell.

Basic example

Let us consider the following inputs with 2 loops and a column that calculate the sum of loops:

If you want to sort values from loop "Input range", you can display dynamically your resulting range by using MM_RANGE:

=MM_RANGE(MM_SORTRANGE(F19:F22,FALSE)

In Mind, your range will be sorted according to each index of your loop "Input range":

Example with several loops

If you want to sort some of the loops range calculated in column H according to the first index of your first loop named "Input range", you will have to write the following formula:

=MM_RANGE(MM_SORTRANGE(H19:H22, FALSE, "Input range", 1))

In Mind, your resulting range is multidimensional with indexes from only loop "Input range 2":