I am creating a new timetable in a school and have the following problem. The students have opted for different subjects and I have create the below:
Id Sex Surname Called Name Form Returning Key Biology Business Std Chemistry Spanish (x2) PE Classicsal Civ German History Maths Physics Psychology
1 F a Charlotte z 1 1
2 M b Daniel y 2 1
3 M a Thomas z 3 1
4 M b Oliver y 4
5 F a Aiman z 5 1
6 M b Edward y 6 1
7 F a Tamara z 7 1
8 F b Lydia y 8 1
9 M a Thomas z 9 1
10 F b Hannah y 10 1
11 M a Alexander z 11 1
12 M b William y 12
13 M a William z 13 1
On seperate worksheets I would like a list of who has opted for each subject. IE produce a list of students who have a 1 in the subject column. What function would be most appropiate?
many thnaks
Id Sex Surname Called Name Form Returning Key Biology Business Std Chemistry Spanish (x2) PE Classicsal Civ German History Maths Physics Psychology
1 F a Charlotte z 1 1
2 M b Daniel y 2 1
3 M a Thomas z 3 1
4 M b Oliver y 4
5 F a Aiman z 5 1
6 M b Edward y 6 1
7 F a Tamara z 7 1
8 F b Lydia y 8 1
9 M a Thomas z 9 1
10 F b Hannah y 10 1
11 M a Alexander z 11 1
12 M b William y 12
13 M a William z 13 1
On seperate worksheets I would like a list of who has opted for each subject. IE produce a list of students who have a 1 in the subject column. What function would be most appropiate?
many thnaks
