I'm tracking test grades for courses in Excel. I filtered individuals that failed the first test for re-test. There are also elimination options that would remove them from retests if they failed their first test and were eliminated. The issue I'm having is to filter names for the second test out that have been eliminated in the first test or the re-test.
The names for the first test are pulling from a data set. First Test Roster
The names for the second test are filtered:
=FILTER(F12:F27,($G$12:$G$27<80%)*(C12:C27="F"),"")
On the re-test for first test
the C12:C27 in the formula are referred to the eliminated button, containing boolean results.
I have tried to filter the names from both lists. Obviously didn't work.
=FILTER(FILTER(F12:F27,C12:C27="T",""),C59:C74="T","")
I was thinking about trying to use a VLOOKUP with FILTER, but don't know where to start.
After doing a little more googling and working through the problem,
=SORT(LET(X,VSTACK(FILTER(F12:F27,(G12:G27>=80%)*(C12:C27="F"),""),FILTER(F59:F74,(G59:G74>=80%)*(C59:C74="F"),"")),FILTER(X,X<>"")))
seems to be giving the results that are expected.