Home > DeveloperSection > Articles > RANK function in Excel

RANK function in Excel


Excel Excel 
Ratings:
0 Comment(s)
 2206  View(s)
Rate this:

RANK function in Excel

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


Don't want to miss updates? Please click the below button!

Follow MindStick