Ranking Issue

Hi All,

Kindly help me a solution for this dashboard, Mr Newdoverman gave a solution last time hence do not want to pester him again ,an other person kindly pls provide a solution

Problem :

•Ranking based on multiple criterion
•Ranking should such that it follows the following sequence : 1)ME 2)HVSB 3)HGSB 4)MMSB 5) Others
•the products are ranked based on revenue contribution which is in coloum G of the spread sheet
•All the team leader who have RM who contribute high revenue by selling ME product should be ranked 1st
•Only when all the ME product is ranked & exhausted the subsequent product needs to be ranked
•The team leader & his RM should remain intact , even if the other Rm’s have other products they should remain with the same team leader but should be ranked under the same team leader in the sequence above.

Regards
Gamefreak