is the value the rank of which is to be determined.
is the array or range of data in the sample.
(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.
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.
Parent topic: List of functions