1. You can filter data into other tables.
2. More complicated screening conditions may be used. Of course, the realized function is far from automatic screening.
Advanced filtering is the play condition area. Here are some basic setup steps according to an example.
Note: this article is original for this site, please indicate "transferred from EXCEL elite training, author: Blue Fantasy".
Example: According to the following data table, filter the records in Shanghai into the worksheet of "Question 1".
1, set the conditional area. The condition area of advanced filtering generally consists of the title line and the condition line below. However, when using a formula, the title line can be left blank. In this example, the a 1: a2 region of the graph1
2. Open the worksheet "Question 1" to perform data-filtering-advanced filtering, and make the following settings in the opened window.
Method: Choose to copy the filtering results to another location. If the filtering results are displayed in this worksheet, you can select the first option.
List Area: Select the data source area.
Condition range: A 1: A2 cell
Copy to: Here, select the third row of the header row set in the Question 1 worksheet. Note that the column headings in the header row should be exactly the same as the field names in the source data table. How many spaces can be wrong.
After setting the previous contents, click OK to filter all Shanghai products into this worksheet.