Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, the average rank is returned.
RANK.AVG(Value; Data; Type)
Value is the value, whose rank is to be determined.
Data is the array or range of data in the sample.
Type (optional) is the sequence order. Type = 0 means descending from the last item of the array to the first (this is the default), Type = 1 means ascending from the first item of the range to the last.
The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.
=RANK.AVG(A10;A1:A50) returns the ranking of the value in A10 in value range A1:A50. If the specified value does not exist within the range, an error message is displayed.