# RANK.AVG

## Content

This function returns the rank of a number in a set of numbers.

## Syntax

`RANK.AVG(number, array, [order])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *number* | [Required] Number whose rank you want to return |
| *array* | [Required] Reference to the set of numbers |
| *order* | [Optional] How the number is ranked, either in descending order (0 or omitted) or ascending order (non-zero value) |

## Remarks

The size of the returned number is relative to other values in the list. The average rank is returned if more than one value has the same rank.

## Examples

`RANK.AVG(B3,B1:B8,1)`
`RANK.AVG(R3C2,R1C2:R8C2,1)`