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

Jump to navigation
Jump to search

Line 17: | Line 17: | ||

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

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

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

|- | |- | ||

Line 29: | Line 29: | ||

|- | |- | ||

|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" | ||

+ | |- | ||

+ | |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 | ||

|} | |} |

## Revision as of 15:24, 6 December 2016

**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 |