I have a spreadsheet to track student loan outs:
Column
A
is the student name
ColumnB
is how many loan outs they have received
ColumnC
is the class period ColumnD
is the teacher name
ColumnE
is the type of loan out received
ColumnF
is the date received ColumnG
is loan out returned.
Columns E
,F
,G
repeat in each row 5 more times.
Column 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