Home
ChangeValuesToRank
This function converts cell values (along a designated axis) to their respective rank position numbers.  It does not re-order, it merely changes the cell values.

Syntax:

ChangeValuesToRank, boolSortAscending, axis

Parameters:

boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)axis – which axis will be used { Row, Column, Page }

Examples:

ChangeValuesToRank,true,Column

This example changes the cell values in each column to the rank number for each value in the column. If there are 10 rows, then the cells would be numbered 1 through 10, with 1 being put in the cell with the highest value.

Comments:

When two (or more) values are the same, they are assigned the same rank number and subsequent values are adjusted (skipped) according to the number of values that were the same. e.g. 1,2,2,4,5 where the second and third values were the same.
 
< Prev   Next >

Reference