Statistical - RANK.AVG Function

Description

The RANK.AVG function returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, the average rank is returned.

Syntax

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

Arguments

Argument	Description	Required/ Optional
Number	The number whose rank you want to find.	Required
Ref	An array of, or a reference to, a list of numbers. Nonnumeric values in Ref are ignored.	Required
Order	A number specifying how to rank number.	Optional

Notes

If Order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order.
If Order is any nonzero value, Excel ranks number as if ref were a list sorted in ascending order.
If the supplied number is not present within the supplied ref, RANK.AVG returns the #N/A error value.
If the values in the supplied ref array are text values, RANK.AVG returns the #N/A error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm