Parameter List
Syntax
RANK_AVG(value, data,
[is_ascending]
)value
The value whose rank will be determined.
data
The array or range containing the dataset to consider.
[optional] is_ascending
Optional. Whether to consider the values in data in descending or ascending order. Default is 0.
More details
RANK_AVG returns the rank of a specified value in a dataset.