Need an account? Click to Register
Home arrow Learn arrow Reference arrow ChangeValuesValues
ChangeValuesValues
This function accepts a set of numeric values that define the boundaries of custom groups. It looks at each cell to see if it is less than the value or equal-or-higher-than the value and replaces the cell value with the respective group number.

Syntax:

ChangeValuesValues, boolSortAscending, axis, count, commaDelimitedValues

Parameters:

boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)axis – an axis value, but it is not used  { Row, Column, Page }

count – the number of values to follow

commaDelimitedValues – a comma-separated list of numbers

Examples:

ChangeValuesValues,false,Row,2,1000,2000

This example examines each cell and determines if it is below the first value, below the second value, or greater than or equal to it.  In each case, it writes a value of 1, 2, or 3 into each cell. 
 
< Prev   Next >

Reference