1Answers
Excel table how to set different pages to filter the same content
Asked by: Margaret 205 views Software
Tables with different pages, I want to filter out the mixed fills
For example, how to set this up, this is not my setting, I want to learn to use it in other forms
+8Votes
Place two worksheets in a single window, as shown: sheet1 is for all students, and sheet2 is the name of a class.
In the blank line of sheet1 corresponding to the same name, enter =if(countif())
Then switch to sheet2, select all the names and press
to switch to sheet1, then this function becomes =if(countif (Sheet2!A1:A44))
Note: In this step, you must add the symbol before the letter (here A) and the number (here 1 and 44). $,=if(countif(Sheet2!$A$1:$A$44))
Finally, add the function =if(countif(Sheet2!$A$1) :$A$44,A2),"S","F"), after the input is completed, press Enter. The one shown as S is the student of this class. If it is displayed as F, it is not. Then pull the fill from this line and all the students can be screened.