Learn how to correctly use the Excel Ranking function to help improve your data analysis. ... Choose the Order: Specify whether you want the ranking in ascending or descending order.

Excel’s oldest ranking function, RANK() has been more or less replaced by more accurate functions, which we’ll look at later. For now, let’s look at RANK() to be comprehensive.

How to add the SORT() function in Excel. The SORT() function is another new dynamic array function. ... The number 1 for ascending sort or -1 for descending, with 1 being the default.