Rank(column) / RankD(column) |
Top Previous Next |
Generates the rank of each data point in column. Higher values ranked first.
The example shows column B containing the rank of column A. This column was generated using Rank(A). Because there are two 18's in the data set, they are both given a rank of 3 and 17.2, the next value, is given a rank of 5.
|