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.

 

clip0350