RANK.AVG function
This function in Excel helps return the statistical rank of a specific value within a list of numbers. The statistical rank is calculated by arranging the number usually, in a descending way and then assigning a position to each value in a list.
