RANK.AVG(x,ref,order)
x: number whose rank you want to find
ref: list of numbers
order: 0 (descending order) or non-zero (ascending order); defaults to 0
In case of a tie, RANK returns the average rank.
This function is Excel 2010 compatible.
PERCENTRANK, RANK.