## How to use the RANK.AVG function

*Article updated on March 09, 2018*

The RANK.AVG function returns the rank of a number in a list of numbers.

The number returned indicates its size relative to other values in the list. If more than one value share the same rank, the average rank is returned.

Formula in cell E3:

### Excel Function Syntax

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

### Arguments

number |
Required. The number whose rank you want to find. |

ref |
Required. A list of numbers. |

[order] |
Optional. A number specifying how to rank number. 0 - Excel ranks number as if ref were a list sorted in descending order. Default value. Any other number - Ascending order. |

### Comments

Nonnumeric values in Ref are ignored.

### Functions in 'Statistical'

The RANK.AVG function function is one of many functions in the 'Statistical' category.