Forum Discussion
Solved
Student Behaviour Tracker
This is a very cheeky request for help. Now approaching 70 I've forgotten most of what I knew about Excel. I'm a Chair of Governors at an 11-16 school. I receive notifications about pupils who have ...
You are welcome. In the attached file i've added suggestions for suspension group, flag and year group. Regards, Oliver.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Since i'm not sure what you exactly want to achieve i've made up a database and a possible solution "By pupil name" only. If this does what you are looking for further reports should be possible. If this doesn't help then please disregard the suggestion.