NxSort - Sort input array

Returns the sorted data set in ascending/descending order with or without duplicate values.


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).



  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



Article is closed for comments.

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