Returns the rank of the sorted values of the dimensions of a specified cell.

Syntax

=MM_RANK(Cell, SortingOrder, [Name, Index], [Name2, Index2], ...)

• Cell
  Multidimensional cell which contains the values for which you want to return the rank.

• 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_RANK is not meant to be used with a range of size bigger than a cell.

• See MM_SORT function to sort the numerical values of the dimensions of a specified cell.

Example

In this example, the first cell contains the formula =RAND() and we are returning the ranks of the simulations using MM_RANK in the second cell as shown below.

We have launched 10 simulations. The results are summarized in the tables below (display of all dimensions).