VoseSortA | Vose Software

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.

 

Navigation