I have a spreadsheet to track student loan outs:
Ais the student name
Bis how many loan outs they have received
Cis the class period Column
Dis the teacher name
Eis the type of loan out received
Fis the date received Column
Gis loan out returned.
G repeat in each row 5 more times.
B has a Counta formula count of each time a loan out is given to that student.
I would like each teacher to have a sheet within that book that lists the students that have 2 or more loan outs instead of having to look at the master list.
So for example, as a teacher I would have a seperate sheet to look at and when a student of mine gets two or more loan outs it would copy that row into my seperate spreadsheet.
So I am looking for a formula or script that would first look in column
B for a number greater than
1 and then by teacher name in column
D and pull the data to the seperate sheet. I would do this for each teacher.
I already have a script running that automatically adds the date when a loan out is entered. I don't know if this possible too. Here is a link to a blank sheet than I am using: Example Sheet