Manuals/calci/RANK
Jump to navigation
Jump to search
RANK(num,r,od)
Where num is the number for which rank to be find and r is a list of numbers and od is a number specifying how to rank number.
It calculates the rank of a number in a list of numbers. The rank of a number means its size relative to other values in a list.
RANK
Let’s see an example in (Column1 Row 1:Column1Row5)
RANK (num,r,od)
i.e. =RANK (C1R5,C1R1:C1R5, 1) is 4
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 8 | 4 | ||
| Row2 | 5.5 | |||
| Row3 | 5.5 | |||
| Row4 | 3 | |||
| Row5 | 6 | |||
| Row6 | ||||
| Row7 | ||||
| Row8 | ||||
| Row9 | ||||
| Row10 |
