Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

RANKAVG

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

RANKAVG(94,C5:C50)
RANKAVG(94,C5:C50,TRUE)
RANKAVG(94,C5:C50,FALSE)

Syntax

RANKAVG(value, data, [order])

  • value - The value whose rank will be returned.
  • data - The array or range containing the dataset.
  • order - [OPTIONAL] Specifies if the ranking follows ascending or decreasing order.

Examples

RANKAVG(94,C5:C50) returns the rank of the value 94 in the cell range C5:C50.

 

Notes

  • If order is 0 (zero) or omitted, the number is ranked as if data is sorted in descending order.
  • If order is any nonzero value, the number is ranked as if data is sorted in ascending order.