| 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:caption – column 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 > |
|---|