In column A I have a list of students. In column B I have the room number. In column C I have the relevant teacher.
I have allocated each child to a sub teacher. There are 19 sub teachers.
I also need to make a list for each teacher of all the kids in the school who is supposed to be with them on sub.
Can I make the list for the teachers using a formula or must I do it manually?