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 results is always 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.