Navigation:  Formula Reference > Spreadsheet Formula Functions >

RANK.AVG

Previous pageReturn to chapter overviewNext page

 

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

Number whose rank you want to return

array

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.

Data Types

Accepts numeric data for the number argument, a reference for the array argument, and numeric data for the order argument. Returns numeric data.

Examples

RANK.AVG(B3,B1:B8,1)

RANK.AVG(R3C2,R1C2:R8C2,1)