Description
Sorts the numerical values of the dimensions of a specified cell.
Warning
This function is deprecated and available for model compatibility only, please use MM_SORTRANGE, MM_SORTRANGES or MM_SORTDIM.
Syntax
=MM_SORT(Cell, SortingOrder, [Name, Index], [Name2, Index2], ...)Cell
Multidimensional cell which contains the values you want to sort.SortingOrder
Boolean which determines the sort order.
Case 1: TRUE for ascending order.
Case 2: FALSE for descending order.Name, Index (optional)
Name and dimension index of the first loop whose results you want to access.Name2, Index2 (optional)
Name and dimension index of the second loop whose results you want to access....
Other loop specifications.
Remarks
MM_SORT is not meant to be used with a range of size bigger than a cell.
See MM_RANK function to return the rank of the sorted values of the dimensions of the input cell.
Example
In this example, the table #Simulations contains the formula =RAND() and we are sorting the values of the simulations using MM_SORT in the #Sorted Table as shown below.
We have launched 10 simulations. The results are summarized in the tables below (display of all dimensions). Notice the difference between the unsorted table and the sorted table.
