| Excerpt |
|---|
This example demonstrates |
...
you to generate a ranked order of values |
...
- If there are three tie values in a group, the next ranking is three more than the tie values.
- See RANK Function.
...
. |
Functions:
| D generate list excerpts | ||
|---|---|---|
|
Source:
The following dataset contains lap times for three racers in a four-lap race. Note that for some racers, there are tie values for lap times.
...
| Runner | Lap | Time | Rank | Rank-Dense |
|---|---|---|---|---|
| Mark | 4 | 70.63 | 1 | 1 |
| Mark | 1 | 71.73 | 2 | 2 |
| Mark | 2 | 71.73 | 2 | 2 |
| Mark | 3 | 72.99 | 4 | 3 |
| Tom | 2 | 70.71 | 1 | 1 |
| Tom | 3 | 71.02 | 2 | 2 |
| Tom | 4 | 72.98 | 3 | 3 |
| Tom | 1 | 74.43 | 4 | 4 |
| Dave | 4 | 70.85 | 1 | 1 |
| Dave | 1 | 72.2 | 2 | 2 |
| Dave | 3 | 72.2 | 2 | 2 |
| Dave | 2 | 73.31 | 4 | 3 |
| D s also | ||
|---|---|---|
|
