Forum Discussion
Create a new list from data already in a workbook
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?
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?
- Yes you can make the list(s) for the teachers using formulas. Try COUNTIFS() and SUMIFS()
N
