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

Have more questions? Submit a request

0 Comments