moderation exam marks4.3.xlsx

	B	C	D	E	F	G	H	I	J	K	L	N	O	Q	R	T	U	V	Z
1
2
3
4													moderation marks
5	No.	Name	Matric No.	Teachers	Class	Math	Sc	Arts	Eng	Geog	History		Math		math
6	1	Abigail	68751	Vanessa	1A	45						Abigail	45	Highest 1	#NAME?		SORT(FILTER(L6:M54,M6:M54>=LARGE(M6:M54,3)),2,-1)		4
7	2	Alexandra	41803	Virginia	1B	89						Alexandra	89	Highest 2		<==			12
8	3	Alison	20636	Wanda	1C	92						Alison	92	Highest 3					13
9	4	Amanda	34789	Wendy	1D	68						Amanda	68	middle 1	#NAME?		?		7
10	5	Amelia	76662	Vanessa	1E	92						Amelia	92	middle 2					13
11	6	Amy	26158	Virginia	1A	92						Amy	92	middle 3					13
12	7	Andrea	95100	Wanda	1B	58						Andrea	58	Lowest 1	#NAME?		SORT(FILTER(L6:M54,M6:M54<=SMALL(M6:M54,3)),2,1)		5
13	8	Angela	21301	Wendy	1C	77						Angela	77	Lowest 2		<==			10
14	9	Anna	96074	Vanessa	1D	36						Anna	36	Lowest 3					2
15	10	Anne	89705	Virginia	1E	39						Anne	39						3
16	11	Audrey	17900	Wanda	1A	62						Audrey	62				Highest 1	#NAME?	6
17	12	Ava	90594	Wendy	1B	69						Ava	69				Highest 2		8
18	13	Bella	13064	Vanessa	1C	71						Bella	71				Highest 3		9
19	14	Bernadette	12687	Virginia	1D	34						Bernadette	34						1
20	15	Carol	80939	Wanda	1E	80						Carol	80						11
21	16	Caroline	43180	Wendy	1A														#N/A
22	17	Carolyn	94793	Vanessa	1B														#N/A
23	18	Chloe	89040	Virginia	1C														#N/A
24	19	Claire	97850	Wanda	1D														#N/A
25	20	Deirdre	40531	Wendy	1E														#N/A
26	21	Diana	44097	Vanessa	1A														#N/A
27	22	Diane	61230	Virginia	1B														#N/A
28	23	Donna	15171	Wanda	1C														#N/A
29	24	Dorothy	25184	Wendy	1D														#N/A
30	25	Elizabeth	33909	Vanessa	1E														#N/A
31	26	Ella	25783	Virginia	1A														#N/A
32	27	Emily	22102	Wanda	1B														#N/A
33	28	Emma	51220	Wendy	1C														#N/A
34	29	Faith	16117	Vanessa	1D														#N/A
35	30	Felicity	38638	Virginia	1E														#N/A
36	31	Fiona	80417	Wanda	1A														#N/A
37	32	Gabrielle	82385	Wendy	1B														#N/A
38	33	Grace	45842	Vanessa	1C														#N/A
39	34	Hannah	37995	Virginia	1D														#N/A
40	35	Heather	24464	Wanda	1E														#N/A
41	36	Irene	54082	Wendy	1A														#N/A
42	37	Jan	77030	Vanessa	1B														#N/A
43	38	Jane	42699	Virginia	1C														#N/A
44	39	Jasmine	21173	Wanda	1D														#N/A
45	40	Jennifer	59635	Wendy	1E														#N/A
46	41	Jessica	88081	Vanessa	1A														#N/A
47	42	Joan	61520	Virginia	1B														#N/A
48	43	Joanne	52450	Wanda	1C														#N/A
49	44	Julia	13994	Wendy	1D
50	45	Karen	22633	Vanessa	1E
51	46	Katherine	18360	Virginia	1A
52	47	Kimberly	97649	Wanda	1B
53	48	Kylie	21344	Wendy	1C
54	49	Lauren	17567	Vanessa	1D
55	50	Leah	26975	Virginia	1E
56	51	Matilda Strong	41748	Wanda	1A
57	52	Jospeh Coleman	38792	Wendy	1B
58	53	Natalie Walter	46132	Vanessa	1C
59	54	Essie Mathews	95760	Virginia	1D
60	55	Caleb Bryan	57680	Wanda	1E
61	56	Aurora Cooke	75561	Wendy	1A
62	57	Carolyn Bentley	58393	Vanessa	1B
63	58	Korey Lynn	29680	Virginia	1C
64	59	Ignacio Mason	60270	Wanda	1D
65	60	Consuelo Byrd	90230	Wendy	1E
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