Rank Function or Rank Formula in Excel with example

Rank Function or Rank Formula in Excel with example

RANK

Function finds rank for a specific number within given range. Rank Function is very useful to calculate various positions within a range. Other words Rank Function returns the rank of a number in a list of numbers.

Syntax

=RANK(number, ref, [order])

Parameters

  • number: a mandatory parameter, refers to the number which needs to be ranked within ref.
  • ref: a mandatory parameter, refers to a range within rank needs to be found
  • order: an optional parameter, excel by default takes descending order rank. But user can change the order

Formula

Output

Next >> Exact function or Exact Formula in Excel with example

Leave a Reply

Your email address will not be published.