Excel RANK.AVG function

Function              RANK.AVG

Description        Excel RANK.AVG function returns rank of a number in a list of numbers. The rank of a number is returned in both ascending and descending order. Excel RANK.AVG function returns the average rank when a number duplicates in the number set.

Syntax  RANK.AVG(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.