1, EXCEL refers some records to other locations according to conditions, so it is more convenient to use advanced filtering;

2. Establish a conditional area, with the field name as the first line and the condition as the second line (if there are multiple field names, the conditions that need to be met at the same time are placed on the same line, and as long as one of them is met, it is placed on a different line);

3. Selection: Data-Sorting and Filtering-Advanced;

4. Open the advanced filtering dialog box and select "Copy filtering results to other locations". The selection area is shown in the following figure;

5. After confirmation, the screening results will be obtained.