itzvenom95
- 2
- 0
I have the following table.
I would like to know how to give an weight to the "12 Month Median Ranking of Opponent" so it changes other two columns depending on how high/low the ranking is.
To put this into perspective, this is regarding tennis players. On the spreadsheet I can have two players facing each other that have the same "12 Month Service Points Won" of 40%. Although Player A has a "12 Month Median Ranking of Opponent" of 300 and Player B of 100. Although the percentages are the same the player who managed to get a 40% "12 Month Service Points Won" against an "12 Month Median Ranking of Opponent" of 100 is extremely better than Player A that managed to get the same 40% against a "12 Month Median Ranking of Opponent" of 300.
I would like a formula to tackle this issue.
Let me know if I wasn't clear on any of my explanation.
I would like to know how to give an weight to the "12 Month Median Ranking of Opponent" so it changes other two columns depending on how high/low the ranking is.
To put this into perspective, this is regarding tennis players. On the spreadsheet I can have two players facing each other that have the same "12 Month Service Points Won" of 40%. Although Player A has a "12 Month Median Ranking of Opponent" of 300 and Player B of 100. Although the percentages are the same the player who managed to get a 40% "12 Month Service Points Won" against an "12 Month Median Ranking of Opponent" of 100 is extremely better than Player A that managed to get the same 40% against a "12 Month Median Ranking of Opponent" of 300.
I would like a formula to tackle this issue.
Let me know if I wasn't clear on any of my explanation.