Excel data representation: show me all people who did not pass the exam
- by dreftymac
Background
I have an excel spreadsheet with the results of a pass/no-pass exam. Students are allowed to take the exam as often as they want until they either pass, or give up trying.
student ;; result ;; date
sally@fiz.edu ;; no-pass ;; 2000-06-07
bravo@fiz.edu ;; pass ;; 2000-06-07
charlie@fiz.edu ;; pass ;; 2000-06-07 …