Comparison operators for Dates and Numbers
Excel Advanced Filter
Operators for Texts
Wildcards
Using advanced filter with AND vs. OR logic
- Criteria on the same row are joined with an AND operator. (both conditions must be met)
- Criteria on different rows are joined with an OR operator. (one of the conditions must be met)
