RANK function
RANK(Number, Array,
Order) RANK(Number; Array;
Order)
Number
Number or { Number }
The value whose rank should be calculated.
Array
{ Number }
The unordered array of data.
Order
Number or { Number }
0 to rank the given numbers with the highest being first and -1 to rank the given numbers with the lowest being first.
Returns
Number or { Number }
A rank of a number in a given array of numbers.
This function is a compatibility alias for RANK.EQ. Use RANK.EQ for new projects.