Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.

RANK.AVG takes 2 required arguments and 1 optional argument:

Syntax: RANK.AVG(number, ref, [order])

#1)
The arguments for the RANK.AVG function are:
Argument Required? Description
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.
comments powered by Disqus