Dueling Excel 91


Rank Scores, But If Tie Award Highest Rank To The Largest Weight

DESCRIPTION

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.

WORKBOOKS




Be the first to comment

Leave a Reply