RANK

Rank a number against a range of numbers

Sponsored Link

RANK

Purpose 

Rank a number against a range of numbers

Return value 

A number that indicates rank.

Syntax 

=RANK (number, array, [order])

Arguments 

  • number - The number to rank.
  • array - An array that contains the numbers to rank against.
  • order - [optional] Whether to rank in ascending or descending order.

Usage notes 

Use RANK when you want to provide a rank for items in a list, but you don't want to sort the list.

The default for order  is 0 = descending order:

If order is 0 or omitted, number is ranked by position against the numbers in array sorted in descending order.

If order is 1, then number is ranked by position against the numbers in array sorted in ascending order.

Sponsored Link

0 votes. 0 / 5