 |
 |
|
 |
 |
|
 |
 |
 |
Description: Returns the rank of a number in a list of numbers; its size relative to other values in the list.
Syntax: RANK(Number, Ref, Order)
Number is the number for which you want to find the rank.
Ref is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored.
Order allows you to specify the sorting order: A value of 0 (or blank) sorts the list in descending order; any nonzero value sorts the list in ascending order.
Example:
RANK(15.5, A1:A100,1) = 10
What's Changed? In previous versions of BlockSim/RENO, the RANK function returned the rank based on the binomial distribution. Starting in Version 11.1.3, you can use the RANK.RS function to return that value.
© 1992-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |