Format for Filter Criteria 
To define a filter, open the sort and filter menu in the column title and choose (Adjust...). Here you formulate the filter criteria for this column. If you define a filter criteria in multiple columns, only those data sets that fulfil each of these criteria are displayed.
Format for Filtering in the Filter Row
To display only those data sets in the current column... |
use... |
Example |
...have the value [Comparison Value] |
[empty] or = |
123 or = 123 |
...has a value that is greater than [Comparison Value] |
> |
> 123 |
...has a value that is less than [Comparison Value] |
< |
< 123 |
...has a value that is either greater than or equal to [Comparison Value] |
>= |
>= 123 |
...has a value that is either less than or equal to [Comparison Value] |
<= |
<= 123 |
...has any value but not the [Comparison Value] |
! . |
! 123 |
...has any value between [Lower Limit] and [Upper Limit] (incl. these limit values) |
. - . |
100 - 123 |
...has a value under [Lower Limit] or over [Upper Limit] but not a value between the two (nor the limit value) |
! . - . |
! 100 - 123 |
...fulfil at least one of many filter criteria |
. ; . |
a - d; p - s |
Note
If you want to use a character string that contains one of the special characters named above (for example, C-1025), then set the whole character string in quotation marks "." (for example, "C-1025")
Using Replacement Characters
You can use a special replacement character (a wildcard character) for one or more characters in the comparison value. This makes it possible for you to find multiple terms with one comparison value. Use the asterisk * as the wildcard in the filter row.
Example
You want to get all data sets that contain terms that end with ouse in the current column, for example, ouse, Blouse, House, or Mouse.
For this, specify the comparison value *ouse.
Escaping Wildcard Characters
To filter the list for a comparison value that contains the character *, you have to tell the system not to interpret the character as a wildcard: You escape the wildcard. To do this, enter the escape character \ in front of the character for which you are searching.
Example
To get all data sets that contain the value *ouse in the current column, use the comparison value \*ouse.