Method: 1. Open two excel tables and select a cell area with more data; 2. Click the "Advanced" button in the "Data" tab; 3. In the "List Area" of the pop-up window Automatically identify the selected cell range, set the "Conditional Range" to the corresponding cell range in another table, and click "OK".

#How to quickly filter out the same data in two tables?

Method:

1 First select a cell range with more data and click the "Advanced" button in the "Data" tab;

2 Automatically identify the selected cell range in the "List Range" text box of the "Advanced Filter" dialog box that opens;

3 Then set the "conditional area" to the corresponding cell area in another table, and then click the "OK" button to filter out the same data in the two tables

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to compare and filter out the same data from two tables?. For more information, please follow other related articles on the PHP Chinese website!