Forum Discussion
Solved
Need help with ranking function
Hello, trying to rank each persons "Player Name" highest value of "Maximum Velocity". I've been successful showing a rank but it's including every single max velocity value, and I just want it to ra...
| Player Name | Activity Name | Date | Maximum Velocity |
| Ath 1 | WLAX Practice 11-3-23 | 11/3/2023 | 14.04 |
| Ath 2 | WLAX Practice 11-3-23 | 11/3/2023 | 13.69 |
| Ath 3 | WLAX Practice 11-3-23 | 11/3/2023 | 13.37 |
| Ath 4 | WLAX Practice 11-3-23 | 11/3/2023 | 17.05 |
| Ath 5 | WLAX Practice 11-3-23 | 11/3/2023 | 15.4 |
| Ath 1 | WLAX Practice 11-6-23 | 11/6/2023 | 12.79 |
| Ath 1 | WLAX Practice 11-6-23 | 11/6/2023 | 9.53 |
| Ath 2 | WLAX Practice 11-6-23 | 11/6/2023 | 14.53 |
| Ath 2 | WLAX Practice 11-6-23 | 11/6/2023 | 11.16 |
| Ath 2 | WLAX Practice 11-6-23 | 11/6/2023 | 10.91 |
| Ath 3 | WLAX Practice 11-6-23 | 11/6/2023 | 13.76 |
| Ath 3 | WLAX Practice 11-6-23 | 11/6/2023 | 9.97 |
| Ath 4 | WLAX Practice 11-6-23 | 11/6/2023 | 11.38 |
| Ath 5 | WLAX Practice 11-6-23 | 11/6/2023 | 10.49 |
The data set is very large so I provided an example below and would like the final ranking to look like this:
Ath 4 - 17.05 - Rank 1
Ath 5 - 15.4 - Rank 2
Ath 2 - 14.53 - Rank 3
Ath 1 - 14.04 - Rank 4
Ath 3 - 13.76 - Rank 5