Skip to main content

RANK.AVG

Definition of RANK.AVG

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

Sample Usage

RANK.AVG(A10, A1:A100, TRUE)

RANK.AVG(B32, B8:B47, FALSE)

RANK.AVG(A10, A1:A100)

Syntax

RANK.AVG(value, data, [is_ascending])

  • value - The value whose rank will be determined.
  • data - The array or range containing the dataset to consider.
  • is_ascending - [ OPTIONAL - default is descending (FALSE] - Whether to consider the values in data in descending or ascending order.

See Also

RANK: Returns the rank of a specified value in a dataset.

RANK.EQ: Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

In order to use the RANK.AVG formula, start with your edited Excellentable

Then type in the RANK.AVG Formula in area you would like to display the outcome:

Type in the complete RANK.AVG formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

A
B
C
1
State
Date
Temp(F)
2
Alabama
7/1/2011
89
3
Alaska
7/2/2011
88
4
Arizona
7/3/2011
92
5
Arkansas
7/4/2011
101
6
California
7/5/2011
94
7
Colorado
7/6/2011
97
8
Connecticut
7/7/2011
95
9
10
4

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.