Manuals/calci/RANKANDPERCENTILE
RANKANDPERCENTILE(Array, GroupBy, NewTableFlag)
where,
Array - Input range should be one block.
GroupBy - Either groupby Columns or Rows.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Creates a list of the numbers ranked from highest to lowest and also provides a percentile value which indicates how an individual number ranks compared to the other numbers.
Lets see an example in (Column3Row1)
=RANKANDPERCENTILE(R1C1:R6C2, "Rows", TRUE)
RANKANDPERCENTILE returns the result in new sheet(5Space).
=RANKANDPERCENTILE(R1C1:R6C1, "Columns", TRUE)
RANKANDPERCENTILE returns the result in new sheet(9Space).
RANK AND PERCENTILE AVERAGE
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 3 | 5Space | |
| Row2 | 7 | 8 | ||
| Row3 | 12 | 5 | ||
| Row4 | 17 | 18 | ||
| Row5 | 41 | 31 | ||
| Row6 | 6 | 9 | 9Space |
| Point | Row1 | Rank | Percent |
|---|---|---|---|
| 1 | 5 | 1 | 100 |
| 2 | 3 | 2 | 0 |
| Point | Row2 | Rank | Percent |
|---|---|---|---|
| 2 | 8 | 1 | 100 |
| 1 | 7 | 2 | 0 |
| Point | Row3 | Rank | Percent |
|---|---|---|---|
| 1 | 12 | 1 | 100 |
| 2 | 5 | 2 | 0 |
| Point | Row4 | Rank | Percent |
|---|---|---|---|
| 2 | 18 | 1 | 100 |
| 1 | 17 | 2 | 0 |
| Point | Row5 | Rank | Percent |
|---|---|---|---|
| 1 | 41 | 1 | 100 |
| 2 | 31 | 2 | 0 |
| Point | Row6 | Rank | Percent |
|---|---|---|---|
| 2 | 9 | 1 | 100 |
| 1 | 6 | 2 | 0 |
| Point | Column1 | Rank | Percent |
|---|---|---|---|
| 5 | 41 | 1 | 100 |
| 4 | 17 | 2 | 80 |
| 3 | 12 | 3 | 60 |
| 2 | 7 | 4 | 40 |
| 6 | 6 | 5 | 20 |
| 1 | 5 | 6 | 0 |