The following table shows which filter operators can be used with the Advanced Filter to filter different kinds of data. If you filter data with an inappropriate operator, all of the data in the list will be filtered out and you will be returned to an empty list.
Data Type |
Contains, |
Comparisons |
Character |
Yes |
Yes |
Numeric |
No |
Yes. The filter value must be a valid number (for example, length cannot be entered as the filter value because it is not a number). Note: When a filter is applied to a numeric column, null and blank values within the column are treated as lower than any numeric value. |
Date |
No |
Yes. The filter value must be a valid date. A blank value may only be used with = and ≠. |
Longitude/Latitude |
Yes |
Yes. The filter value must be a valid latitude or longitude in dd:mm:ss.ss format. |
Boolean |
No |
You can only use = and ≠. The filter value must be a valid Boolean (valid formats are y/n, true/false, yes/no). |