# Difference between revisions of "Manuals/calci/RANKS"

Jump to navigation
Jump to search

Line 17: | Line 17: | ||

==Examples== | ==Examples== | ||

− | + | 1.RANKS([32,67,12,10,23],3,0) | |

{| class="wikitable" | {| class="wikitable" | ||

|- | |- | ||

Line 30: | Line 30: | ||

|67 || 1 ||4 | |67 || 1 ||4 | ||

|} | |} | ||

− | + | 2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5) | |

{| class="wikitable" | {| class="wikitable" | ||

|- | |- | ||

Line 49: | Line 49: | ||

|210.3 || 1 ||13 | |210.3 || 1 ||13 | ||

|} | |} | ||

+ | |||

==See Also== | ==See Also== | ||

*[[Manuals/calci/RANK | RANK ]] | *[[Manuals/calci/RANK | RANK ]] |

## Revision as of 16:09, 27 February 2018

**RANKS(r,n,o)**

- is the set of numbers.
- is the number to get ranked.
- is the number to start.

## Description

- This function gives the ranks of a each number in given set of numbers.
- It is based on the value of a number, relative to the other numbers in the list.
- In RANK(r,n,o), is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order.
- is the number to be get ranked.
- If o is zero, then the list of the numbers getting in descending order.
- If o is 1, then the list of the numbers getting in ascending order.
- When we are not mentioning the o value, then it will give the set of numbers in descending order.
- RANKS gives the spare numbers that having the same rank.
- The occurrence of the spare number affects the ranks of the next numbers.
- This function will return the result as error when any one of the argument is non-numeric.

## Examples

1.RANKS([32,67,12,10,23],3,0)

10 | 1 | 0 |

12 | 1 | 1 |

23 | 1 | 2 |

32 | 1 | 3 |

67 | 1 | 4 |

2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5)

10.002 | 1 | 5 |

32 | 1 | 6 |

32.2 | 1 | 7 |

45 | 1 | 8 |

54.01 | 2 | 9.5 |

76 | 1 | 11 |

100 | 1 | 12 |

210.3 | 1 | 13 |

## See Also

## References