Returns the rank of a number in a sample.
RANK(Value; Data; Type)
Value is the value, whose rank is to be determined.
Data is the array or range of data in the sample.
Type (optional) is the sequence order. Type = 0 means descending from the last item of the array to the first (this is the default), Type = 1 means ascending from the first item of the range to the last.
=RANK(A10;A1:A50) returns the ranking of the value in A10 in value range A1:A50. If the specified value does not exist within the range, an error message is displayed.