How to use Excel’s RANK.AVG() function In almost every way, Excel’s RANK.AVG() function performs as RANK(), except in one way: RANK.AGE() returns an average rank if a number occurs more than once.

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).

RANK.AVG and RANK.EQ() were added to Excel 2010 (.xlsx). I’m including demonstration files for both the .xlsx and .xls formats , but only RANK() will work in versions earlier than Excel 2010.