Rank Scores, But If Tie Award Highest Rank To The Largest Weight
See Mr Excel and excelisfun use two methods to rank scores with the heights Weight:
1. See how to use RANK or RANK.EQ and SUMPRODUCT functions and an array to calculate rank when there are ties.
2. See how to use the RANK function and COUNTIF and the Sort Feature.