articles

Home / DeveloperSection / Articles / RANK function in Excel

RANK function in Excel

AVADHESH PATEL4792 30-Mar-2013

In Microsoft Excel, the RANK function returns the rank of a number within a set of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

Syntax
RANK(number,ref,[order]) 

The RANK function syntax has the following arguments: 

  •      Number     Required. The number whose rank you want to find.
  •      Ref     Required. An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
  •      Order     Optional. A number specifying how to rank number.
Note:

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. 

If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order. 

RANK function in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By