How to flip the ranked results in Microsoft Excel Earlier, I mentioned that RANK.EQ () has an optional argument to determine the sort.

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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...