Excel Function : RANK.EQ

Download now!

Excel Function : RANK.EQ

Category

Statistical

Description

Returns the rank of a number in a list of numbers

Microsoft Excel Reference Page

https://support.office.com/en-us/article/RANKEQ-function-284858ce-8ef6-450e-b662-26245be04a40

Syntax and Description of the RANK.EQ Excel Function

The RANK.EQ function syntax is =RANK.EQ(number, ref, [order]) number - The number whose rank you want to find ref - The array or range of data to consider [order] - The order to rank number in. Optional. Default is 0

About RANK.EQ Excel Function

The RANK.EQ function returns the rank of a number in a list of numbers. The rank is the position of the number in the list, with the first position being 1.