User Guide for Advanced Filter Mode

Feature Summary

When you need to process large amounts of sheet data and standard filters cannot meet the requirements for complex multi-criteria queries, Advanced Filter Mode supports custom criteria ranges to achieve multi-criteria "AND/OR" combination filtering, helping you precisely extract target data and simplifying complex data query and analysis work.

Feature Description

Steps

Advanced Filter Mode

Feature Entry ①
Data tab > Filter > Advanced Filter

1. Open a WPS Sheets document and select a cell with content.
2. Click the Data tab on the top menu bar.
3. Click the Filter drop-down button.
4. Select Advanced Filter.
5. The Advanced Filter dialog box will appear.

Feature Entry ②
Home tab > Filter > Advanced Filter

1. Open a WPS Sheets document and select a cell with content.
2. Click the Home tab on the top menu bar.
3. Click the Filter drop-down button.
4. Select Advanced Filter.
5. The Advanced Filter dialog box will appear.

Set Up Filter Criteria

Feature Entry
Advanced Filter dialog box

1. In Action, choose how to output the filter results:

   • Filter the list, in-place: Filter directly on the original data.
   • Copy to another location: Output the results to a specified range.

2. Set List range: Select the data range to be filtered.

3. Set Criteria range: Select the pre-prepared criteria range (including headers and criteria values).

4. Optionally check Unique records only to remove duplicates.

5. Click OK to run the filter.

FAQ

Q1: What is the difference between Advanced Filter and standard filter?

• Solution: Standard filters can only set criteria for a single column, while Advanced Filter supports custom criteria ranges, enabling multi-column and multi-criteria "AND/OR" combination queries.

Notes

• Use Unique records only to automatically remove duplicate rows.