Alexander_Ewing
New Member
- Joined
- Jan 18, 2005
- Messages
- 9
Hello all,
I am trying to create an At risk register so i can track my student that have several classes.
Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set period (26th February 2018- 15th Mar 2018)(12th March 2018- 29th March 2018) and check if it has more than 2 (A or L), it will then copy the students name to my sheet so i can chase them up.
I am trying to create an At risk register so i can track my student that have several classes.
Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set period (26th February 2018- 15th Mar 2018)(12th March 2018- 29th March 2018) and check if it has more than 2 (A or L), it will then copy the students name to my sheet so i can chase them up.