order
Ordinal numbers to cells in ascending order
Result = order(expression)
Let n be the number of non missing value cells on expression. These cell values are set in order and numbered on Result in ascending order: the cell with the smallest value on expression is assigned a 1 and the cell with the largest value is assigned a number n. Cells on expression with identical values are assigned consecutive, unique numbers; the order in which these cells are numbered is arbitrarily chosen.
A cell with missing value on expression is not considered in the order operation; it is assigned a missing value on Result.
This operation belongs to the group of Order
Result.map |
Expr.map |