Use the RANK function to determine the rank of sales - Basic Statistical Functions - Microsoft Excel Tutorials

Use the RANK function to determine the rank of sales using Microsoft Excel

To compare sales of several days and rank them, use 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:

1. In cells A2:A10 enter dates.
2. In cells B2:B10 enter the sales for each date.
3. Select cells C2:C10 and type the following formula: =RANK(B2,$B$2:$B$10).
4. Press <-Ctrl+Enter->.

Use the RANK function to determine the rank of sales

Note: If you want to rank in ascending order, use this formula: =RANK(B2,$B$2:$B$10,1).