Filter by condition

When selecting a filter by condition, the autofilter is used by default. The AutoFilter allows you to apply filtering with conditions for the most common data type in the selected range: number, date, or text.

To apply filtering with conditions for any type of data, regardless of how often that type occurs in the selected range, use the advanced filter.

When using the auto filter, you can only filter by one condition, while when using the advanced filter, you can filter by one or two conditions.

The advanced filter can be applied to regular cell ranges and table cells, but is not supported in pivot tables.

Filters created in third-party editors that contain conditions not supported in MyOffice Spreadsheet are converted to filters by value. When you open the sort and filter window for such filters, a block with a corresponding notification is displayed. The notification will be displayed until the user applies the new filter settings.