SimulationValuesArray.Ordered
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationValuesArray.Ordered(Reference Cell, Reference Cell)
Function arguments:
| Reference Cell | Cell to use as data source |
| Reference Cell | Cell to use for ordering |
Returns all values from the simulation, as an array (1 column by n rows).
This function returns returns the values from one cell, sorted by the values in a second cell.
This is an array function. You can enter it in a range of cells using Ctrl + Shift + Enter, or you can enter it into a single cell and use Excel’s spill function.