Excel Function : RANK

Download now!

Excel Function : RANK

Category

Compatibility

Description

Returns the rank of a number in a list of numbers

Microsoft Excel Reference Page

https://support.office.com/en-us/article/RANK-function-6a2fc49d-1831-4a03-9d8c-c279cf99f723

Syntax and Description of the RANK Excel Function

The RANK function in Excel returns the rank of a number in a list of numbers. The syntax of the function is as follows: RANK(number, ref, [order]) where the arguments are as follows: number - The number for which you want to find the rank. ref - The array of numbers that is to be ranked. [order] - Optional. The order in which the numbers are to be ranked. If order is 1 or omitted, the numbers are ranked in descending order. If order is 2, the numbers are ranked in ascending order. For example, to find the rank of the number 9 in the list {2, 9, 5, 1

About RANK Excel Function

RANK function in excel is used to return the rank of a given number in a list of numbers. The rank can be given as a number or as a percentile.