Spreadsheet: 101800d1299845841-excel-2007-filtering-excel-problem-march-2011
Sheet: Sheet1

Reg Group | Art A2L KS3 Yr7 Term 1 | Art A2L KS3~2 Yr7 Term 2 | Art A2L KS3~3 Yr7 Term 3 | Eng A2L KS3 Yr7 Term 1 | Eng A2L KS3~2 Yr7 Term 2 | Eng A2L KS3~3 Yr7 Term 3
7A | * | 1 | 1 | 2 | 1 | 2
7A | 2 | 1 | 1 | 2 | 2 | 2
7A | 2 | * | 2 | 2 | 2 | 3
7A | 1 | * | 1 | 2 | 1 | 1
7A | * | 1 | * | 2 | 3 | 2
7A | 1 | 1 | 1 | 2 | 2 | 2
7A | 2 | 1 | 2 | 2 | 2 | 3
7A | 2 | * | 2 | 3 | 2 | 2
7A | * | 1 | * | 2 | 2 | 2
7A | 1 | 1 | 1 | 1 | 2 | 2
7A | 1 | * | 1 | 2 | 1 | 1
7A | * | 1 | * | 2 | 3 | 2
7A | 1 | 1 | 2 | 2 | 2 | 2
7A | 1 | * | 1 | 2 | 2 | 2
7A | * | 1 | * | 2 | 2 | 1
7A | 2 | 1 | 1 | 2 | 2 | 2
7A | 1 | * | 1 | 2 | 2 | 1
7A | * | 1 | * | 1 | 2 | 2
7A | 1 | 1 | 1 | 1 | 2 | 1
7A | 1 | * | 1 | 2 | 1 | 1
7A | * | 1 | * | 2 | 3 | 2
7A | 1 | 2 | 1 | 3 | 3 | 2
7A | 1 | * | 1 | 2 | 1 | 1
7A | 2 | * | 2 | 4 | 3 | 2
7A | * | 1 | * | 2 | 2 | 1
7A | 1 | 1 | 1 | 2 | 1 | 1
7A | 1 | * | 1 | 2 | 2 | 2
7A | * | 1 | * | 2 | 2 | 1
7A | 2 | 2 | 1 | 2 | 2 | 1
7A | 1 | 1 | 1 | 3 | 2 | 1
7B | * | 1 | * | 1 |  | 1
7B | 1 | 1 | 1 | 1 | 2 | 1
7B | 2 | * | 2 | 2 | 2 | 3
7B | 1 | * | 1 | 2 | 2 | 2
7B | * | 1 | * | 2 | 2 | 2
7B | * | 1 | * | 2 | 2 | 1
7B | 1 | 1 | 1 | 1 | 2 | 1
7B | 3 | * | 3 | 2 | 2 | 3
7B | * | 1 | * | 2 | 1 | 2
7B | * | * | * | 4 | 4 | 4
7B | 1 | 1 | 1 | 2 | 2 | 2
7B | 1 | * | 1 | 1 | 2 | 1
7B | 1 | * | 1 | 2 | 2 | 1
7B | * | * | * | 1 | 1 | 1
7B | 1 | 1 | 1 | 1 | 1 | 1
7B | 1 | * | 1 | 2 | 2 | 2
7B | * | 1 | * | 1 | 1 | 2
7B | 2 | 1 | 2 | 1 | 1 | 2
7B | 1 | * | 1 | 2 | 2 | 2
7B | 1 | * | 1 | 1 | 1 | 1
7B | 2 | * | * | 2 | 2 | 2
7B | * | 1 | * | 2 | 1 | 2
7B | 1 | 1 | 1 | 4 | 2 | 3
7B | 1 | 1 | 1 | 1 | 1 | 2
7B | 1 | * | 1 | 1 | 1 | 1
7B | 2 | * | * | 2 | 2 | 2
7B | * | 1 | * | 2 | 2 | 1
7B | 2 | 1 | 1 | 2 | 2 | 2
7B | 1 | 1 | 1 | 1 | 2 | 2
7B | 1 | * | 1 | 1 | 1 | 1
7C | 2 | 2 | 3 | 2 | 2 | 3
7C | * | 1 | 1 | 1 | 1 | 1
7C | 1 | * | 1 | 3 | 2 | 2
7C | * | 1 | * | 2 | 2 | 2
7C | 2 | 1 | 1 | 2 | 2 | 2
7C | 1 | * | 1 | 1 | 1 | 1
7C | * | 1 | * | 2 | 1 | 1
7C | 1 | 1 | 2 | 1 | 1 | 1
7C | 1 | * | 1 | 1 | 2 | 2
7C | * | 2 | * | 2 | 2 | 2
7C | 3 | 3 | 3 | 2 | 4 | 4
7C | 1 | * | 1 | 2 | 1 | 1
7C | * | 1 | * | 1 | 1 | 1
7C | 1 | 1 | 1 | 2 |  | 2
7C | 2 | 1 | 1 | 2 | 1 | 1
7C | 1 | 1 | 1 | 1 | 1 | 1
7C | * | 2 | * | 2 | 2 | 1
7C | 1 | 1 | 1 | 2 | 1 | 1
7C | 1 | * | 1 | 2 | 2 | 2
7C | * | 2 | * | 2 | 2 | 2
7C | 3 | 2 | 3 | 2 | 3 | 3
7C | 2 | * | 2 | 2 | 2 | 2
7C | 2 | * | 2 | 2 | 4 | 3
7C | 1 | * | 1 | 2 | 2 | 2
7C | * | 1 | * | 2 | 1 | 1
7C | 1 | * | 1 | 1 | 1 | 1
7D | 2 | * | 2 | 1 | 2 | 1
7D | * | 1 | * | 1 | 1 | 1
7D | 3 | 3 | 4 | 3 | 3 | 4
7D | 2 | 1 | 1 | 3 | 2 | 2
7D | * | 1 | * | 1 | 1 | 1
7D | 1 | * | 1 | 2 | 2 | 2
7D | * | 1 | 2 | 3 | 2 | 2
7D | 1 | * | 1 | 1 | 2 | 1
7D | 2 | * | 2 | 3 | 2 | 3
7D | * | 2 | * | 2 | 2 | 2
7D | 1 | 1 | 1 | 1 | 2 | 1
7D | 1 | 2 | 1 | 2 | 2 | 1
7D | * | 1 | * | 2 | 2 | 1
7D | 3 | 1 | 1 | 1 | 2 | 1
7D | * | 1 | * | 1 | 1 | 1
7D | 1 | * | 1 | 1 | 2 | 1
7D | * | 1 | * | 1 | 2 | 1
7D | * | 2 | * | 2 | 2 | 2
7D | 1 | 1 | 1 | 1 | 1 | 1
7D | 1 | * | 1 | 1 | 2 | 1
7D | * | 2 | * | 2 | 2 | 1
7D | 1 | 1 | 1 | 1 | 1 | 1
7D | * | 1 | * | 2 | 2 | 1
7D | * | 2 | * | 2 | 2 | 1
7D | 1 | 2 | 1 | 2 | 2 | 2
7D | 1 | * | 1 | 2 | 1 | 1
7D | 1 | 1 | 1 | 2 | 2 | 1
7D | 3 | 2 | 2 | 3 | 4 | 2
7D | * | 1 | * | 1 | 1 | 1
7E | 2 | * | 2 | 3 | 2 | 3
7E | 2 | * | 2 | 2 | 2 | 2
7E | * | 1 | * | 2 | 2 | 2
7E | 2 | * | 1 | 3 | 3 | 2
7E | * | 1 | * | 2 | 2 | 3
7E | 2 | * | 1 | 2 | 2 | 3
7E | 1 | * | 1 | 1 | 1 | 2
7E | * | 1 | * | 1 | 1 | 1
7E | 1 | * | 1 | 1 | 1 | 1
7E | 1 | * | 1 | 2 | 2 | 2
7E | 2 | * | 2 | 3 | 2 | 2
7E | 2 | * | 1 | 4 |  | 2
7E | * | 1 | * | 2 | 2 | 1
7E | 2 | * | 2 | 2 | 3 | 2
7E | 2 | * | 1 | 2 | 2 | 2
7E | 2 | * | 2 | 2 | 2 | 4
7E | * | 1 | * | 1 | 2 | 2
7E | 1 | * | 1 | 2 | 2 | 2
7E | 2 | * | 1 | 2 | 2 | 2
7E | * | 1 | * | 3 | 2 | 2
7E | 1 | * | 1 | 2 | 1 | 1
7E | 2 | * | 2 | 3 | 2 | 2
7E | * | 2 | * | 2 | 2 | 2
7E | 1 | * | 2 | 2 | 2 | 2
7E | 1 | * | 1 | 1 | 1 | 1
7E | * | 1 | * | 2 | 2 | 3
7E | 1 | * | 1 | 1 | 1 | 1
7E | 2 | * | 1 | 2 | 2 | 1
7F | 1 | * | 1 | 1 | 1 | 2
7F | * | 1 | * | 2 | 2 | 2
7F | 1 | * | 1 | 1 | 1 | 1
7F | 1 | * | 1 | 1 | 2 | 3
7F | 1 | * | 1 | 1 | 1 | 1
7F | 1 | * | 1 | 1 | 1 | 1
7F | * | 1 | * | 2 | 2 | 3
7F | * | 1 | * | 2 | 3 | 3
7F | 2 | * | 1 | 2 | 2 | 3
7F | 1 | * | 1 | 1 | 2 | 2
7F | 1 | * | 1 | 1 | 1 | 1
7F | * | 1 | * | 2 | 2 | 2
7F | 1 | * | 1 | 1 | 2 | 1
7F | * | 4 | * | 2 | 3 | 3
7F | * | 1 | * | 2 | 2 | 3
7F | 2 | 1 | 1 | 2 | 2 | 3
7F | * | 2 | * | 1 | 2 | 4
7F | 1 | * | 1 | 1 | 2 | 2
7F | 1 | * | 2 | 1 | 1 | 1
7F | * | 1 | * | 2 | 3 | 3
7F | 2 | * | 2 | 3 | 2 | 2
7F | 1 | * | 1 | 1 | 2 | 2
7F | 1 | * | 1 | 1 | 1 | 1
7F | * | 1 | * | 1 | 1 | 2
7F | 1 | * | 1 | 1 | 2 | 1
7F | 1 | * | 1 | 1 | 1 | 1
7F | 2 | 1 | * | 2 | 2 | 2
7H | 1 | * | 1 | 1 | 2 | 1
7H | * | 1 | 1 | 1 | 2 | 1
7H | 1 | * | 2 | 1 | 2 | 2
7H | * | 1 | 1 | 2 | 3 | 2
7H | * | 1 | 1 | 2 | 1 | 2
7H | 1 | 1 | 3 | 3 | 2 | 3
7H | 1 | * | 1 | 2 | 3 | 1
7H | * | 1 | 1 | 2 | 1 | 3
7H | 1 | 1 | 1 | 1 | 1 | 1
7H | 1 | * | 1 | 1 | 2 | 1
7H | * | 1 | 1 | 1 | 2 | 2
7H | 1 | 1 | 1 | 1 | 2 | 1
7H | 1 | * | 1 | 1 | 2 | 1
7H | * | 1 | 1 | 2 | 1 | 3
7H | 1 | 1 | 1 | 1 | 1 | 1
7H | 1 | * | 1 | 1 | 2 | 1
7H | * | 1 | 1 | 1 | 1 | 1
7H | * | 1 | 1 | 1 | 3 | 2
7H | 1 | 1 | 1 | 1 | 1 | 2
7H | 1 | * | 1 | 1 | 2 | 2
7H | * | * | 1 |  |  | 4
7H | 1 | 1 | 1 | 1 | 2 | 1
7H | 2 | 1 | 1 | 2 | 3 | 2
7H | 1 | * | 1 | 1 | 2 | 1
7H | * | 1 | 1 | 1 | 1 | 1
7H | 1 | 1 | 1 | 1 | 3 | 1
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Eng T3
Grade 1
[NAME]
[NAME]
[NAME]