I'm busy learning Excel, but I have to provide a formula to the pupils who passed. The names and grades of everyone with a "X" next to "exam passed" must appear under "who passed?" Who Passed? does not require all of the students without a "X" behind their names to appear.
I attempted an if statement, but I am not receiving the desired outcomes.