RANK

Formulas / RANK
Determines the relative rank of a given number compared to other numbers in a list or array
=RANK(number,ref,[order])
  • number - the number to rank
  • ref - the range of numbers to rank against
  • order - [OPTIONAL] indicates if ranking is done in ascending or descending order

Examples

  • =RANK(A1,A1:A5,0)

    The RANK() function returns the position of a number in a list of numbers, relative to the other values in the list. The example above will return 5 if the values 1-5 are in the range A1:A5 and the values are ranked in descending order by setting order to 0.

  • =RANK(A1,A1:A5,1)

    The RANK() function will also return the position of a number in a list of numbers, relative to the other values in the list. This function will return 1 if the values 1-5 are in the range A1:A5 and the values are ranked in ascending order by setting order to 1.


Summary

The RANK function is a way of determining the relative size of a number compared to other numbers within a list by calculating the position a number would take in a sorted list.

  • The RANK function can rank values from largest to smallest, for example for finding top sales, and from smallest to largest, for example for finding fastest time.
  • The RANK function doesn't require sorting list values before using it.
  • The RANK function returns the same rank for duplicates numerical values.
  • Use RANK.EQ or RANK.AVG instead of RANK because RANK is a compatibility function.

Frequently Asked Questions

What is the RANK function?
The RANK function is a function in Sourcetable used to find a number's rank in a list. The rank of a number is how big the number is versus the other numbers in the list; it is the same as the position in a sorted list.
Will the RANK function be supported in future versions of Excel?
No, the RANK function will not be supported in future versions of Excel.
What new RANK functions should I use?
The new RANK functions that should be used include RANK.AVG and RANK.EQ. These new RANK functions provide more accurate calculations than the original RANK function.
What happens if there are duplicate numbers?
The RANK function returns the same rank for duplicate numbers.
Will the RANK function return accurate calculations if there are any non-numeric values in the reference argument?
No, the RANK function does not return accurate calculations if there are any non-numeric values in the reference argument.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV