How to Use the RANK function to determine the rank of sales
To compare sales of several days and rank them, we will emply the use of the RANK function. This function returns a number that is the rank of a value. In this example, the list can be sorted to display sales in rank order.
RANK(number, ref, order)
number: The number for which we want to find the rank.
ref: A reference to a list of numbers. Only numeric values are considered.
order: A number that specifies the ranking method. If order is 0 or omitted, the numbers are ranked in descending order. If order is a nonzero value, the numbers are ranked in ascending order.
To rank a list in descending order:
- In cells A2:A10 enter dates.
- In cells B2:B10 enter the sales for each date.
- Select cells C2:C10 and type the following formula: =RANK(B2,$B$2:$B$10).
- Press Ctrl+Enter.
If you want to rank in ascending order, use this formula: =RANK(B2,$B$2:$B$10,1).
