Here, we will learn how to use the Excel statistical function: RANK.
RANK function
The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. The function can be found in all the versions of Excel. RANK takes the arguments like this: (number, ref, [order]), of which number and ref are required arguments and order is an optional argument. Number accepts the number to rank, ref accepts the range containing numbers to rank against and order determines whether to rank in ascending or descending order. 0 will rank descending, which is the default value and 1 will rank ascending.
The formula in C3, copied down, is:
=RANK(B3,$B$3:$B$11)
You have successfully learnt how to use the Excel statistical function: RANK.
