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:

  • 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 Starter, Excel Online



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language