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