Kevin Neufeld
Board Regular
- Joined
- Oct 6, 2014
- Messages
- 50
I know I have done this before but for the life of me cannot find the spreadsheet I saved as an example. In column c I have a rank, by the value in column b. the formula would start over each time the id # changes. In other words its in a data set I keep adding to. I have a formula that ranks like that but creates ties in the rank. I do not want a tie. See column D for this example.
| ID# | value | rank | Desired outcome |
1 | 24.5 | 1 | 1 |
1 | 29.5 | 2 | 2 |
1 | 30.5 | 3 | 3 |
1 | 30.5 | 3 | 4 |
1 | 32 | 4 | 5 |
1 | 33 | 5 | 6 |
1 | 33 | 5 | 7 |
1 | 33.5 | 6 | 8 |
2 | 26 | 1 | 1 |
2 | 26.5 | 2 | 2 |
2 | 27 | 3 | 3 |
2 | 27 | 3 | 4 |
2 | 27.5 | 4 | 5 |
2 | 28 | 5 | 6 |
2 | 28 | 5 | 7 |
2 | 28 | 5 | 8 |
2 | 28.5 | 6 | 9 |
2 | 29.5 | 7 | 10 |
2 | 30.5 | 8 | 11 |
2 | 31.5 | 9 | 12 |
2 | 32 | 10 | 13 |
2 | 34 | 11 | 14 |
2 | 36 | 12 | 15 |
2 | 37 | 13 | 16 |
3 | 24.5 | 1 | 1 |
3 | 25 | 2 | 2 |
3 | 25 | 2 | 3 |
3 | 25 | 2 | 4 |
3 | 26 | 3 | 5 |
3 | 26.5 | 4 | 6 |
3 | 26.5 | 4 | 7 |
3 | 26.5 | 4 | 8 |
3 | 27 | 5 | 9 |
3 | 27 | 5 | 10 |
3 | 28 | 6 | 11 |
3 | 28.5 | 7 | 12 |
3 | 29 | 8 | 13 |
3 | 30 | 9 | 14 |
3 | 32 | 10 | 15 |
4 | 26 | 1 | 1 |
4 | 27 | 2 | 2 |
4 | 27.5 | 3 | 3 |
4 | 28 | 4 | 4 |
4 | 28 | 4 | 5 |
4 | 28 | 4 | 6 |
4 | 28.5 | 5 | 7 |
4 | 29 | 6 | 8 |
4 | 30 | 7 | 9 |
4 | 30.5 | 8 | 10 |
5 | 27 | 1 | 1 |
5 | 28 | 2 | 2 |
5 | 28 | 2 | 3 |
5 | 28.5 | 3 | 4 |
5 | 30.5 | 4 | 5 |
5 | 30.5 | 4 | 6 |
5 | 31 | 5 | 7 |
5 | 33 | 6 | 8 |
5 | 33.5 | 7 | 9 |
5 | 33.5 | 7 | 10 |
5 | 34.5 | 8 | 11 |
5 | 35 | 9 | 12 |
5 | 35 | 9 | 13 |
5 | 35.5 | 10 | 14 |
5 | 36 | 11 | 15 |
