Spreadsheet: 742893d1628096525-excel-power-query-dense-rank-excel-forum-example-workbook
Sheet: Sheet1

Date | race_id | race_rpr | RPR Rank | RPR Rank2 | Rank Needed |  | Date | race_id | race_rpr | Rank
2021-07-31 00:00:00 | 788251 | 111 |  |  | 5 |  | 2021-07-31 00:00:00 | 788251 | 111 | 5
2021-07-31 00:00:00 | 788251 | 110 |  |  | 4 |  | 2021-07-31 00:00:00 | 788251 | 110 | 4
2021-07-31 00:00:00 | 788251 | 109 |  |  | 3 |  | 2021-07-31 00:00:00 | 788251 | 109 | 3
2021-07-31 00:00:00 | 788251 | 108 |  |  | 2 |  | 2021-07-31 00:00:00 | 788251 | 108 | 2
2021-07-31 00:00:00 | 788251 | 107 |  |  | 1 |  | 2021-07-31 00:00:00 | 788251 | 107 | 1
2021-07-31 00:00:00 | 788251 | 107 |  |  | 1 |  | 2021-07-31 00:00:00 | 788251 | 107 | 1
2021-07-31 00:00:00 | 788251 | 107 |  |  | 1 |  | 2021-07-31 00:00:00 | 788251 | 107 | 1
2021-07-31 00:00:00 | 788251 | 107 |  |  | 1 |  | 2021-07-31 00:00:00 | 788251 | 107 | 1
2021-07-31 00:00:00 | 788253 | 88 |  |  | 6 |  | 2021-07-31 00:00:00 | 788253 | 88 | 6
2021-07-31 00:00:00 | 788253 | 75 |  |  | 5 |  | 2021-07-31 00:00:00 | 788253 | 75 | 5
2021-07-31 00:00:00 | 788253 | 68 |  |  | 4 |  | 2021-07-31 00:00:00 | 788253 | 68 | 4
2021-07-31 00:00:00 | 788253 | 58 |  |  | 3 |  | 2021-07-31 00:00:00 | 788253 | 58 | 3
2021-07-31 00:00:00 | 788253 | 40 |  |  | 2 |  | 2021-07-31 00:00:00 | 788253 | 40 | 2
2021-07-31 00:00:00 | 788253 |  |  |  | 1 |  | 2021-07-31 00:00:00 | 788253 |  | 1
2021-07-31 00:00:00 | 788253 |  |  |  | 1 |  | 2021-07-31 00:00:00 | 788253 |  | 1
2021-07-31 00:00:00 | 788253 |  |  |  | 1 |  | 2021-07-31 00:00:00 | 788253 |  | 1
2021-07-31 00:00:00 | 788253 |  |  |  | 1 |  | 2021-07-31 00:00:00 | 788253 |  | 1
2021-07-31 00:00:00 | 788255 | 89 |  |  | 5 |  | 2021-07-31 00:00:00 | 788255 | 89 | 5
2021-07-31 00:00:00 | 788255 | 86 |  |  | 4 |  | 2021-07-31 00:00:00 | 788255 | 86 | 4
2021-07-31 00:00:00 | 788255 | 85 |  |  | 3 |  | 2021-07-31 00:00:00 | 788255 | 85 | 3
2021-07-31 00:00:00 | 788255 | 85 |  |  | 3 |  | 2021-07-31 00:00:00 | 788255 | 85 | 3
2021-07-31 00:00:00 | 788255 | 84 |  |  | 2 |  | 2021-07-31 00:00:00 | 788255 | 84 | 2
2021-07-31 00:00:00 | 788255 | 81 |  |  | 1 |  | 2021-07-31 00:00:00 | 788255 | 81 | 1
2021-07-31 00:00:00 | 788256 | 74 |  |  | 9 |  | 2021-07-31 00:00:00 | 788256 | 74 | 9
2021-07-31 00:00:00 | 788256 | 73 |  |  | 8 |  | 2021-07-31 00:00:00 | 788256 | 73 | 8
2021-07-31 00:00:00 | 788256 | 73 |  |  | 8 |  | 2021-07-31 00:00:00 | 788256 | 73 | 8
2021-07-31 00:00:00 | 788256 | 72 |  |  | 7 |  | 2021-07-31 00:00:00 | 788256 | 72 | 7
2021-07-31 00:00:00 | 788256 | 72 |  |  | 7 |  | 2021-07-31 00:00:00 | 788256 | 72 | 7
2021-07-31 00:00:00 | 788256 | 71 |  |  | 6 |  | 2021-07-31 00:00:00 | 788256 | 71 | 6
2021-07-31 00:00:00 | 788256 | 71 |  |  | 6 |  | 2021-07-31 00:00:00 | 788256 | 71 | 6
2021-07-31 00:00:00 | 788256 | 70 |  |  | 5 |  | 2021-07-31 00:00:00 | 788256 | 70 | 5
2021-07-31 00:00:00 | 788256 | 70 |  |  | 5 |  | 2021-07-31 00:00:00 | 788256 | 70 | 5
2021-07-31 00:00:00 | 788256 | 70 |  |  | 5 |  | 2021-07-31 00:00:00 | 788256 | 70 | 5
2021-07-31 00:00:00 | 788256 | 69 |  |  | 4 |  | 2021-07-31 00:00:00 | 788256 | 69 | 4
2021-07-31 00:00:00 | 788256 | 69 |  |  | 4 |  | 2021-07-31 00:00:00 | 788256 | 69 | 4
2021-07-31 00:00:00 | 788256 | 68 |  |  | 3 |  | 2021-07-31 00:00:00 | 788256 | 68 | 3
2021-07-31 00:00:00 | 788256 | 67 |  |  | 2 |  | 2021-07-31 00:00:00 | 788256 | 67 | 2
2021-07-31 00:00:00 | 788256 | 63 |  |  | 1 |  | 2021-07-31 00:00:00 | 788256 | 63 | 1