RANK function

RANK returns the rank of a number in a sample.

Syntax

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.

Example

=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.




Trademarks | IBM Connections wiki