Home
FilterByNumeric
This function filters (removes) the rows based on the cell values in a data column relative to a specified value and operator.

Syntax:

FilterByNumeric, caption, criteria, value

Parameters:

captioncolumn caption to use

criteria – the criteria to be used when filtering { LessThan, LessThanOrEqualTo, NotEqual, Equal, GreaterThanOrEqualTo, GreaterThan }

value – the numeric value to be used

Examples:

FilterByNumeric,Data_One,LessThan,100

Remove a row if the actual value in the column identified as “Data_One” is Less Than 100.

Change History:

v3.1 - new command

 
< Prev   Next >

Reference