Excel for the web supports all three ranking functions, for now. How to use Excel’s RANK() function. Excel’s oldest ranking function, RANK() has been more or less replaced by more accurate ...

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.