NxSort - Sort input array

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

  1. The input data set may span multiple rows and/or columns, but the results is always one-dimensional array (i.e. column).
  2. The missing values in the input data set are purged prior to the ordering

Files Examples

References

Comments

Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful