Syntax. RANK.AVG(number,ref,order)
Definition. This function returns the rank of a number within a list of numbers. The rank of a number is its size relative to the other values in a list. If several values have the same rank, the average rank is returned.
number (required). The value for which you want to know the rank.
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 numbers. If order is 0 or not specified, the number is ranked as if ref were a list sorted in descending order. If order is a nonzero value, the number is ranked as if ref were a list sorted in ascending order.
Background. You will find more information in the description of RANK().
Example. For information about the use of the RANK.AVG() function, see the example for the RANK() function.
Sample Files
Use the RANK.AVG worksheet in the Count.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
18.216.255.250