Data > Rank

The rank utility assigns ranks to numerical values in a column. The ranks are computed as follows:

To use the utility, select Data > Rank. In the rank dialog, select the column containing data to be ranked using the Rank Data in: dropdown menu. Enter the column or variable name for storing ranks in the Store Ranks in: text box.

Example

The following shows the ranks of the values in C1:
C1ranks
2 1.0
5 2.0
7 3.5
7 3.5
8 5.0
9 6.0