VoseSortD

Download a pdf copy of this help file  here

See also: VoseSortA, VoseSmallest, VoseLargest

VoseSortD(Data,Line,DataInRows)

Example model

Array function that returns the input data in descending 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.