Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula
<tbody>
</tbody>
MBR | Rank | NPI | Rank | CORR | Rank | FINAL RANK | |||
NG | 9.83 | 1 | 14.63 | 1 | 233 | 8 | ? | ||
MW | 9.78 | 2 | 9.67 | 4 | 237 | 7 | ? | ||
LS | 9.35 | 4 | 4.64 | 9 | 450 | 2 | ? | ||
RB | 9.40 | 3 | 7.73 | 6 | 296 | 4 | ? | ||
CN | 9.30 | 5 | 6.43 | 8 | 279 | 6 | ? | ||
JP | 8.75 | 6 | 10.91 | 3 | 190 | 9 | ? | ||
TM | 8.42 | 9 | 6.96 | 7 | 417 | 3 | ? | ||
MM | 8.62 | 8 | 8.03 | 5 | 506 | 1 | ? | ||
SM | 8.67 | 7 | 13.86 | 2 | 288 | 5 | ? |
<tbody>
</tbody>