Create a new list from data already in a workbook

[Rixba]

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?

[#2]

Yes you can make the list(s) for the teachers using formulas. Try COUNTIFS() and SUMIFS()

N