RANK function

RANK returns the rank of a number in a sample.


RANK (number, ref, order)

number is the value the rank of which is to be determined.

ref is the array or range of data in the sample.

order (optional) is the sequence order.

  • Order = 0 means descending from the last item of the array to the first (this is the default),
  • Order = 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 number does not exist within the range an error message is displayed.