The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain duplicates, the RANK.AVG function will assign an average rank to each set of duplicates.
Syntax:= RANK.AVG (number, ref, [order])
The RANK.AVG function syntax has the following arguments:
- Number Required. The number whose rank you want to find.
- Ref Required. An array of, or a reference to, a list of numbers. Nonnumeric values in Ref are ignored.
Order Optional. A number specifying how to rank number.
Example: Let’s look at some Excel RANK.AVG function examples and explore how to use the RANK.AVG function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following RANK.AVG examples would return:
- If Order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order.
- If Order is any nonzero value, Excel ranks number as if ref were a list sorted in ascending order.
- If the supplied number is not present within the supplied ref, RANK.AVG returns the #N/A error value.
- If the values in the supplied ref array are text values, RANK.AVG returns the #N/A error value.