Order is the only optional argument and identifies how to rank number: 0 is the default and can be omitted: ranks in descending order.

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix Excel ranking by ...

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.