How to filter the same data in two tables

How to filter the same data in two tables

Put two worksheets in one window, such as As shown in the picture: sheet1 is for all students, sheet2 is the names of students in a certain class.

Input =if (countif()) in the blank of the same line of the corresponding name in sheet1

and then switch Go to sheet2, select all the names and press Enter

## Then switch to sheet1, then the function becomes =if(countif(Sheet2!A1:A44))

Note: In this step, the letters (A here) and numbers (1 and 44 here) must be preceded by the symbol $,=if(countif( Sheet2!$A$1:$A$44))

Finally, complete the function =if(countif(Sheet2!$A$1:$A$44,A2),"S","F"), After the input is completed, press Enter. Those shown as S are students in this class, and those shown as F are not. Then pull down the fill from this row, and all students can be filtered.

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