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

RANK

Returns the rank of a specified value in a dataset. 

Sample Usage

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

Syntax

RANK(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

RANK(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.