VoseSortA

See also: VoseSortD, VoseSmallest, VoseLargest

VoseSortD(Data,Line,DataInRows)

 

 

Example model

Array function that returns the input data in ascending order - it can sort both text and values. If the input array has multiple columns, you can specify the column against which to sort.

  • Data - the data to be sorted.

  • Line - if Data contains multiple columns/rows, the column (or row) against which to sort. Should be an integer value

  • DataInRows - optional boolean parameter (TRUE/FALSE) specifying whether the data is in columns (FALSE, default) or rows (TRUE)

This can be of use if you need to work with a sorted list of generated random values. Excel can sort but not dynamically, so sorting a list of randomly generated values is undone on spreadsheet recalculation.

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->