Subject Combos.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AD	AF	AG
1		Art	Biology	Business	Chemistry	Classics	Computing	Drama	DT	Economics	English	French	Further Maths	Geography	History	ICT	Latin	Maths	Music	PE	Physics	Psychology	RE	Spanish
2	Art		2	0	0	1	0	1	0	0	0	1	0	0	0	1	0	1	1	1	1	1	1	0		Option 1	Option 2	Option 3
3	Biology			0	0	1	0	2	0	0	0	0	0	0	2	1	0	1	0	1	0	0	1	1	ifNA(IF(AND(MATCH($a$2,Z3:AB3,0),MATCH($B$1,Z3:AB3,0))=TRUE,1,0),0)	Music	French	Art	0	Economics	1
4	Business				0	1	1	2	0	0	1	0	0	1	0	0	1	0	0	1	0	0	2	0	ifNA(IF(AND(MATCH($A$2,Z4:AB4,0),MATCH($B$1,Z4:AB4,0))=TRUE,1,0),0)	Biology	History	ICT	0	Drama	1
5	Chemistry					0	0	0	1	1	2	0	0	0	1	1	0	2	0	0	1	1	0	2	ifNA(IF(AND(MATCH($A$2,Z5:AB5,0),MATCH($B$1,Z5:AB5,0))=TRUE,1,0),0)	Latin	Spanish	Further Maths	0
6	Classics						0	2	0	0	0	1	1	0	1	1	2	2	0	0	0	0	2	1	ifNA(IF(AND(MATCH($A$2,Z6:AB6,0),MATCH($B$1,Z6:AB6,0))=TRUE,1,0),0)	History	Computing	Maths	0
7	Computing							2	2	1	0	0	0	1	2	1	1	2	0	2	2	0	1	0	ifNA(IF(AND(MATCH($A$2,Z7:AB7,0),MATCH($B$1,Z7:AB7,0))=TRUE,1,0),0)	Classics	French	Drama	0
8	Drama								0	1	2	3	0	0	0	0	0	1	0	1	0	0	1	0	ifNA(IF(AND(MATCH($A$2,Z8:AB8,0),MATCH($B$1,Z8:AB8,0))=TRUE,1,0),0)	Computing	Maths	Physics	0
9	DT									0	1	0	0	0	1	1	0	1	0	0	1	0	0	0	ifNA(IF(AND(MATCH($A$2,Z9:AB9,0),MATCH($B$1,Z9:AB9,0))=TRUE,1,0),0)	Classics	Spanish	Maths	0
10	Economics										1	0	1	0	0	0	1	0	1	1	0	0	0	0	ifNA(IF(AND(MATCH($A$2,Z10:AB10,0),MATCH($B$1,Z10:AB10,0))=TRUE,1,0),0)	Economics	Chemistry	English	#N/A
11	English											1	0	0	0	0	0	0	0	0	0	0	0	0	ifNA(IF(AND(MATCH($A$2,Z11:AB11,0),MATCH($B$1,Z11:AB11,0))=TRUE,1,0),0)	DT	History	Computing	0
12	French												0	0	1	1	0	0	1	1	0	0	0	0	ifNA(IF(AND(MATCH($A$2,Z12:AB12,0),MATCH($B$1,Z12:AB12,0))=TRUE,1,0),0)	RE	Biology	Classics	0
13	Further Maths													0	1	0	1	1	0	1	0	0	1	1	ifNA(IF(AND(MATCH($A$2,Z13:AB13,0),MATCH($B$1,Z13:AB13,0))=TRUE,1,0),0)	RE	Physics	Art	0
14	Geography														0	0	0	0	0	0	0	1	1	0	ifNA(IF(AND(MATCH($A$2,Z14:AB14,0),MATCH($B$1,Z14:AB14,0))=TRUE,1,0),0)	PE	Computing	Latin	0
15	History															2	1	2	0	0	0	1	0	1	ifNA(IF(AND(MATCH($A$2,Z15:AB15,0),MATCH($B$1,Z15:AB15,0))=TRUE,1,0),0)	Classics	ICT	Art	0
16	ICT																0	0	0	0	0	0	0	1	ifNA(IF(AND(MATCH($A$2,Z16:AB16,0),MATCH($B$1,Z16:AB16,0))=TRUE,1,0),0)	PE	Drama	French	0
17	Latin																	2	1	1	0	1	3	1	ifNA(IF(AND(MATCH($A$2,Z17:AB17,0),MATCH($B$1,Z17:AB17,0))=TRUE,1,0),0)	Drama	RE	Computing	0
18	Maths																		0	0	3	1	1	2	ifNA(IF(AND(MATCH($A$2,Z18:AB18,0),MATCH($B$1,Z18:AB18,0))=TRUE,1,0),0)	Biology	Maths	Drama	0
19	Music																			0	0	0	0	0	ifNA(IF(AND(MATCH($A$2,Z19:AB19,0),MATCH($B$1,Z19:AB19,0))=TRUE,1,0),0)	Spanish	Chemistry	ICT	0
20	PE																				1	0	1	0	ifNA(IF(AND(MATCH($A$2,Z20:AB20,0),MATCH($B$1,Z20:AB20,0))=TRUE,1,0),0)	History	Maths	Latin	0
21	Physics																					0	1	0	ifNA(IF(AND(MATCH($A$2,Z21:AB21,0),MATCH($B$1,Z21:AB21,0))=TRUE,1,0),0)	PE	Art	Biology	0
22	Psychology																						2	0	ifNA(IF(AND(MATCH($A$2,Z22:AB22,0),MATCH($B$1,Z22:AB22,0))=TRUE,1,0),0)	Spanish	Biology	History	0
23	RE																							0	ifNA(IF(AND(MATCH($A$2,Z23:AB23,0),MATCH($B$1,Z23:AB23,0))=TRUE,1,0),0)	Art	Psychology	Maths	0
24	Spanish																								ifNA(IF(AND(MATCH($A$2,Z24:AB24,0),MATCH($B$1,Z24:AB24,0))=TRUE,1,0),0)	Drama	French	English	0
25																									ifNA(IF(AND(MATCH($A$2,Z25:AB25,0),MATCH($B$1,Z25:AB25,0))=TRUE,1,0),0)	Computing	PE	Physics	0
26																									ifNA(IF(AND(MATCH($A$2,Z26:AB26,0),MATCH($B$1,Z26:AB26,0))=TRUE,1,0),0)	English	Drama	Business	0
27																									ifNA(IF(AND(MATCH($A$2,Z27:AB27,0),MATCH($B$1,Z27:AB27,0))=TRUE,1,0),0)	Maths	Latin	Classics	0
28																									ifNA(IF(AND(MATCH($A$2,Z28:AB28,0),MATCH($B$1,Z28:AB28,0))=TRUE,1,0),0)	Physics	Chemistry	Maths	0
29																									ifNA(IF(AND(MATCH($A$2,Z29:AB29,0),MATCH($B$1,Z29:AB29,0))=TRUE,1,0),0)	Chemistry	Spanish	Maths	0
30																									ifNA(IF(AND(MATCH($A$2,Z30:AB30,0),MATCH($B$1,Z30:AB30,0))=TRUE,1,0),0)	Further Maths	Classics	History	0
31	G1	G2	G3	G4				Art	2																ifNA(IF(AND(MATCH($A$2,Z31:AB31,0),MATCH($B$1,Z31:AB31,0))=TRUE,1,0),0)	Physics	DT	Maths	0
32	Art	Biology	Psychology					Biology	2																ifNA(IF(AND(MATCH($A$2,Z32:AB32,0),MATCH($B$1,Z32:AB32,0))=TRUE,1,0),0)	Chemistry	History	Psychology	0
33	Business	Physics	Maths	Classics				Business	2																ifNA(IF(AND(MATCH($A$2,Z33:AB33,0),MATCH($B$1,Z33:AB33,0))=TRUE,1,0),0)	Geography	Computing	Business	0
34	Chemistry	RE	Latin	Economics				Chemistry	2																ifNA(IF(AND(MATCH($A$2,Z34:AB34,0),MATCH($B$1,Z34:AB34,0))=TRUE,1,0),0)	RE	Further Maths	Maths	0
35	Further Maths	French	Drama	Music				Classics	2																ifNA(IF(AND(MATCH($A$2,Z35:AB35,0),MATCH($B$1,Z35:AB35,0))=TRUE,1,0),0)	History	French	ICT	0
36	Spanish	History	DT	ICT				Computing	2																ifNA(IF(AND(MATCH($A$2,Z36:AB36,0),MATCH($B$1,Z36:AB36,0))=TRUE,1,0),0)	Drama	Economics	Computing	1
37	Computing	English	Business	PE				Drama	2																ifNA(IF(AND(MATCH($A$2,Z37:AB37,0),MATCH($B$1,Z37:AB37,0))=TRUE,1,0),0)	Business	RE	Latin	0
38	Geography	Art	Biology	Chemistry				DT	2																ifNA(IF(AND(MATCH($A$2,Z38:AB38,0),MATCH($B$1,Z38:AB38,0))=TRUE,1,0),0)	PE	Economics	Further Maths	#N/A
39	Classics	Computing		DT				Economics	2																ifNA(IF(AND(MATCH($A$2,Z39:AB39,0),MATCH($B$1,Z39:AB39,0))=TRUE,1,0),0)	Drama	Biology	Art	0
40	Economics	ICT	French	Further Maths				English	2																ifNA(IF(AND(MATCH($A$2,Z40:AB40,0),MATCH($B$1,Z40:AB40,0))=TRUE,1,0),0)	Geography	Psychology	RE	0
41	Drama	Geography	History	Latin				French	2																ifNA(IF(AND(MATCH($A$2,Z41:AB41,0),MATCH($B$1,Z41:AB41,0))=TRUE,1,0),0)	English	DT	Chemistry	0
42	Music	Maths	PE	Physics				Further Maths	2																ifNA(IF(AND(MATCH($A$2,Z42:AB42,0),MATCH($B$1,Z42:AB42,0))=TRUE,1,0),0)	Latin	Classics	RE	0
43	Psychology	Spanish	RE	English				Geography	2																ifNA(IF(AND(MATCH($A$2,Z43:AB43,0),MATCH($B$1,Z43:AB43,0))=TRUE,1,0),0)	Business	Drama	Classics	0
44								History	2																ifNA(IF(AND(MATCH($A$2,Z44:AB44,0),MATCH($B$1,Z44:AB44,0))=TRUE,1,0),0)	Music	Latin	Economics	#N/A
45								ICT	2																ifNA(IF(AND(MATCH($A$2,Z45:AB45,0),MATCH($B$1,Z45:AB45,0))=TRUE,1,0),0)	RE	Business	PE	0
46								Latin	2																ifNA(IF(AND(MATCH($A$2,Z46:AB46,0),MATCH($B$1,Z46:AB46,0))=TRUE,1,0),0)	Psychology	Latin	RE	0
47								Maths	2																ifNA(IF(AND(MATCH($A$2,Z47:AB47,0),MATCH($B$1,Z47:AB47,0))=TRUE,1,0),0)	ICT	DT	Computing	0
48								Music	2
49								PE	2
50								Physics	2
51								Psychology	2
52								RE	2
53								Spanish	2
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100