Recent content by itzvenom95

Here's another photo that might help with this problem. I would like to come up with a formula that takes the ranking of opponent into account, giving more or less value to the other two columns.

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...