A B C D E F 1 name handed in students assignments name missing 2 a 1 a 1 b 2 3 b 1 b 2 b 3 4 c 1 c 3 c 2 5 a 2 6 c 3 7 a 3
Say I am a teacher so:
- C has a list of all students enrolled in my class;
- D has a list of all assignments;
- Each and every student in C must hand in all of the assignments listed in D;
- A and B I keep feeding with student name and assignment handed in.
Now, at the end of the day, I wanna know who are the bad students who have not handed in all of their assignments.
I need a formula that lists in E and F the student name and the assignments they were supposed to have handed in.
In my sample data student "a" is a good student, student "b" missed out assignments 2 and 3 and student "c" missed out assignment 2.