Home

Create a new list from data already in a workbook

Rixba
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()

N
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies