Use RANK.EQ and RANK.AVG: Excel offers two additional ranking functions: RANK.EQ (equivalent to RANK) and RANK.AVG (which assigns the average rank to tied values).

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...