Create a new list from data already in a workbook

Occasional Visitor
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?
1 Reply
Yes you can make the list(s) for the teachers using formulas. Try COUNTIFS() and SUMIFS()

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies