Returns the sorted data set in ascending/descending order with or without duplicate values.
Syntax
NxSort(X, order, return_type)
- X
- is the input data sample (one/two-dimensional array of cells (e.g. rows or columns)).
- order
- is the order method (1 = ascending (default), 2 = descending).
- return_type
- is a switch to select the output data set ( 1 = unique values (default), 2 = allow duplicates).
Remarks
- The input data set may span multiple rows and/or columns, but the result is always a one-dimensional array (i.e. column).
- The missing values in the input data set are purged prior to the ordering.
Files Examples
References
- Hamilton, J .D.; Time Series Analysis, Princeton University Press (1994), ISBN 0-691-04289-6.
- Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740.
Comments
Article is closed for comments.