i am busy learning excel but i need to show the passed students with a formula. everyone with a "X" at "exam passed" need to show up under "who passed?" with all the grades and names. all the students without a "X" behind their name don't need to show up under "Who Passed?"

I tried a if statement but i am not getting the results i want

CodePudding user response：

FILTER Function: "filters" a range of data based on supplied criteria(X). The result is an array(B2:E7) of matching values(X) from the original range(G2:G7).

=FILTER(B2:E7,G2:G7="X")