Dueling Excel 91

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.


Be the first to comment

Leave a Reply