Excel Function : RANK.AVG

Download now!

Excel Function : RANK.AVG




Returns the rank of a number in a list of numbers

Microsoft Excel Reference Page


Syntax and Description of the RANK.AVG Excel Function

The syntax for the RANK.AVG function in Microsoft Excel is: =RANK.AVG(number,ref,order) Where the function arguments are as follows: Number - The number that you want to rank. Ref - The array of numbers that you want to rank number against. Order - [optional] The order in which you want to rank the numbers in ref. order can be one of the following values: 1 - Rank in descending order. 0 or omitted - Rank in ascending order.

About RANK.AVG Excel Function

RANK.AVG function returns the rank of a number in a list of numbers. The rank is relative to other values in the list. The list can be supplied as an array or a reference.