T Tech56 Member Feb 11, 2020 #1 Hi, What would be the formulas in V5:V10 to get the results for 1st, 2nd, etc. ? This needs to take into account the value percentages on row 4. For instance the value of Matches is 60% worth of points for the rankings. Thank you Attachments Rank From 3 Ranges.xlsx 13.2 KB · Views: 10
Hi, What would be the formulas in V5:V10 to get the results for 1st, 2nd, etc. ? This needs to take into account the value percentages on row 4. For instance the value of Matches is 60% worth of points for the rankings. Thank you
Chihiro Excel Ninja Feb 11, 2020 #2 Try... =[@Column3]*$X$3+[@Column4]*$Y$3+[@Column5]*$Z$3 A & C are tied.
