RANK.AVG works fine with sorted or unsorted data.
It is not necessary to sort the values in the list before using the RANK.AVG function.
By default, RANK.AVG will rank values indescendingorder and assign an average rank to tied values in the list.
This behavior can be reversed using the optionalorderargument as explained below.
This is the only difference between RANK.EQ and RANK.
The optionalorderargument is not provided, since RANK.AVG will assign an average rank to tie values by default.
Also, note that theorderargument is provided as 1 to force RANK.AVG to rank the times inascendingorder.
The RANK.AVG function is designed to follow the second approach.
One advantage of using an average rank is that the sum of ranks (10) is preserved.
As mentioned above, the RANK.AVG function handles ties by assigning anaverage rankto tied values.
RANK is the original ranking function in Excel.
RANK and RANK.EQ are essentially the same function.
There should be no cases where RANK and RANK.EQ return different results.
In contrast, the RANK.AVG function will assign tie values anaverage rank.
The “AVG” in the name denotes the “average rank” behavior.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
from a set of numeric data.
