​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.