A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

By using the Excel Ranking function, you can effortlessly rank each team member’s sales figures, ... Consider using the RANK.EQ or RANK.AVG functions to handle duplicates differently. 5.

An average rank might not be what you need, so let’s review the last of Excel’s ranking function, RANK.EQ(). How to use Excel’s RANK.EQ() Excel’s RANK.AVG() corrects for duplicate values ...