RANK.AVG function

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.

Syntax

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

The RANK.AVG function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

  • 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.

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order.

If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.

 
 
Applies to:
Excel 2010, Excel Web App