Syntax :

=RANK.AVG( number, ref, [order] )

Parameters :

• The following parameter are:

number –

• The value for which you wish to calculate the rank.

ref –

• A value array holding the provided number.

[order] –

• An optional parameter specifying whether the given ref array should be arranged ascending or descending.
  The [order] option can have a value of 0 or 1, which means:
• 0 – use descending order;
• 1 – use ascending order.
  1st – use ascending order
  If the [order] option is missing, the default value of 0 is used (i.e. descending order). Any non-zero number is assumed to be the value 1. (i.e. ascending order).