Manuals/calci/RANK

From ZCubes Wiki
Revision as of 04:15, 15 January 2014 by Devika (talk | contribs)
Jump to navigation Jump to search
RANK(n,r,o)


  • is the number to be ranked.
  • is the range of numbers .
  • indicates the number is ranked in ascending or descending order.


Description

  • This function gives the rank of a given set of numbers.
  • It is based on the value of a number, relative to the other numbers in the list.
  • In is the number to be get ranked, is the range of the cells to find the ranking the number and indicates the number is ranked in ascending or descending order.
  • If is zero, then the list of the numbers getting in descending order.
  • If is 1, then the list of the numbers getting in ascending order.
  • When we are not mentioning the value, then it will give the set of numbers in descending order.
  • 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 nonnumeric.


Examples

1. Number={20,7,5,17,32} RANK(7,C1:C5,0)=4 RANK(7,C1:C5,1)=2 2. Number={10,4,-1,0,15,24,45} RANK(4,G1:G7,0)=5 RANK(4,G1:G7,1)=3 RANK(-1,G1:G7,0)=7 3. Number={4,-1,-47,-23,0,-18,1,-35} RANK(0,H1:H8,0)=3 RANK(0,H1:H8,1)=6 RANK(-18,H1:H8,1)=4

Spreadsheet
A B C D E F G H
1 20 7 5 17 32
2 10 4 -1 0 15 24 45
3 4 -1 -47 -23 0 -18 1 -35