Excel advanced filtering operation content

Take the following table as an example. From the table on the left, you need to filter out the people with the specified names on the right.

Click Advanced in the filtering in the [Data] column, and select [Copy filter results to other locations] in the advanced filtering. Then select the table you want to filter in the list area. Remember to select the header. In the condition area, select the table on the right, which is the object you want to find. Finally, copy to the blank cell you want to copy.

Finally click OK, and a filtered form will be generated.

The above is the detailed content of Excel advanced filtering operation content. For more information, please follow other related articles on the PHP Chinese website!