excel formula set rank ordering problem

Users questions: Annex has been set up to help me master the formula, if I want to add the three ranking methods a "wolf" team, ask what should set up the formula? Thank you ... ...
Experts answer: names defined in the original formula because it defines the name is not dynamic, of course, you add data to change the name of the area. The d ata = $ i $ 2: $ i $ 8 ...... Attachment: sort formula. rar
  • This information provided by the users.Thanks!