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.
