When switching to the advanced filter, the editor will attempt to convert the condition specified in the autofilter to Condition 1 if the conditions correspond (see the table below). For example, if the auto filter has the condition “Exact date: May 10, 2025,” then when the advanced filter is enabled, Condition 1 will appear as “Equal to: May 10, 2025.” When you switch to autofilter mode, the condition will also be converted.
Advanced filter condition |
Autofilter condition |
|---|---|
Number |
|
Equal to |
Equal to |
Not equal to |
Not equal to |
Greater than |
Greater than |
Greater than or equal to |
Greater than or equal to |
Less that |
Less that |
Less than or equal to |
Less than or equal to |
Greater than or equal to (for the first autofilter value) |
Between |
No correspondence |
Above average |
No correspondence |
Below average |
No correspondence |
Top 10 |
No correspondence |
Bottom 10 |
Starts with |
No correspondence |
Ends with |
No correspondence |
Contains |
No correspondence |
Does not contain |
No correspondence |
Date |
|
Equal to |
Exact date |
Not equal to |
No correspondence |
Greater than |
After |
Greater than or equal to |
No correspondence |
Less that |
Before |
Less than or equal to |
No correspondence |
Starts with |
No correspondence |
Ends with |
No correspondence |
Contains |
No correspondence |
Does not contain |
No correspondence |
Text |
|
Equal to |
Equal to |
Not equal to |
Not equal to |
Greater than |
No correspondence |
Greater than or equal to |
No correspondence |
Less that |
No correspondence |
Less than or equal to |
No correspondence |
Starts with |
Starts with |
Ends with |
Ends with |
Contains |
Contains |
Does not contain |
Does not contain |