RANK

Rank a number against a range of numbers

RANK

Summary 

The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK function can arrange values from largest to smallest as well as smallest to largest values, using an optional order argument.

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.

0 votes. 0 / 5