RANK.AVG

The RANK.AVG function returns the rank of a numeric value compared to a list of other numeric values. RANK.AVG can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). When RANK.AVG encounters duplicates, it will assign an average rank to each set of duplicates. RANK.AVG works fine with sorted or unsorted data — it is not necessary to sort the values in the list before RANK.AVG. The basic syntax for RANK.AVG looks like this: where number is the value you want to rank, ref is a range that contains numbers to rank against, and order is an optional argument for controlling the ranking direction. By default, RANK.AVG will rank values in descending order and assign an average rank to tied values in the