WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How can we use RANK function

Uploaded time: August 27, 2021 Difficulty Intermediate

How can we use RANK function

How can we use RANK function

RANK function is a statistical function thatcan quickly calculate the rank of a number in a list of numbers.

Taking this sales table as an example, how do we rank the sales volume in the first quarter?

First, we can place the cursor in cell F3, click the Formulas tab, and Insert Function button to find RANK function. At this time, the Function Arguments dialog box will pop up.

Number is the number for which you want to find the rank. Ref is an array of, or a reference to, a list of numbers. Select E3: E14 here, then click Shift+F4 to make an absolute reference to the array area. Adding an absolute reference prevents the region we quote from being confused.

Order is the choice of ranking ascending or descending. 0 or omitted means that rank in the list is sorted descending; any nonzero value means that rank is sorted.

Click OK to get Arthur's ranking, and double-click to fill the formula to get the ranking of all employees.

To learn more about using functions, you're welcome to enter WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.