Range Filter
Input
- From Value – lower bounds of the range filter
- Through Value – upper bound of the range filter
Options
Filter type:
- Is Between – Construct an inclusive range filter. “>=A:<=B”
- Is Not Between – Construct an exclusion range filter. “<=A;>=B”
From option:
- From – Indicates to include the ‘From Value’ in the range. (>=)
- From and excluding – Indicates to not include the ‘From Value’ in the range. (>)
Through option:
- Through – Indicates to include the ‘Through Value’ in the range (<=)
- Through and excluding – Indicates to not include the ‘Through Value’ in the range. (<)
Summary
Ease of use method for constructing range filters to be used for such things as Table Lookup calculations (make sure to use the Column as filter setting as opposed to just Column when specifying how to query the target table).
Behaves like the Range Filter visual assist dialog with the added option of creating an exclusion range.
If either option is blank, that part of the filter will be omitted.
This calculation can be used in formulas.