Excel - Rank Lesson

Rank Function

​Rank Syntax

=RANK(number, ref, [order])

​Rank Syntax

1. Number (required argument) – This is the value for which we need to find the rank.

2. Ref (required argument) – Can be a list of, or an array of, or reference to, numbers.

3. Order (optional argument) – This is a number that specifies how the ranking will be done (ascending or descending order).

   • 0 – is used for descending order

   • 1 – is used for ascending order

Note

1. #N/A! error – Occurs when the given number is not present in the supplied reference. Also, the RANK function does not recognize text representations of numbers as numeric values, so we will also get the #N/A error if the values in the supplied ref array are text values.

2. If we provide logical values, we will get the #VALUE! error.

Multiple Choice

=RANK(C5,$C$5:C$10,0)

Is this the correct formula to use to rank in descending order.

• No

• Yes

Multiple Choice

What does the RANK function do in Excel?

• The RANK function in Excel calculates the average of a range of numbers

• The RANK function in Excel assigns a rank to a specified number within a list of numbers.

• The RANK function in Excel returns the maximum value in a list of numbers

• The RANK function in Excel sorts the numbers in ascending order

Multiple Select

The RANK function uses the following arguments:

• Number

• Ref

• Order

• Sum

Multiple Choice

This function is used to return the placement/positioning of a numeric value when compared to a list of other numeric values.

• SUM()

• IF()

• RANK()

• VLOOKUP()