Excel RANK function

Function              RANK

Description        Excel RANK function returns rank of a number in a list of numbers. The rank of a number is returned in both ascending and descending order.

Syntax  RANK(number,ref,[order])

Number     Required. The number of which rank to be found.

Ref     Required. An array of, or a reference to, a list of numbers. If there are non=numeric values then those will be ignored.

Order     Optional. It shows a dropdown menu. 0 – Descending order, 1 – Ascending order. By default it is 0 if omitted.

Example:

Usage Notes:

  • If number is not in ref (set of number) then this function returns #N/A error.
  • Excel RANK function returns a #VALUE! error value if number input is not numeric.