Ranking with Frequency and Mean

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Diana	3	Joana	Hannah	Name C7	Name A6	Name B7	Value 1st	# of 1sts	Row #	New Range	Ranked By Value	Value	Ave. Row #	Final Ranking	Value	Ave. Row #
2	Ben	0	Michael	Name B9	Name C4	Name B2	Name B2	5	1	20	B21:B60	Name C2	5	6.80	Name C2	5	6.80
3	Michael	4	Name B1	Name B1	Name B9	Name C2	Name C7	Value 2nd	# of 2nds	3	B4:B60	Michael	4	6.00	Michael	4	6.00
4	Hannah	3	Name B4	Name C3	Name C9	Name C8	Name A7	4	1	1	B2:B60	Diana	3	9.67	Name C7	3	3.00
5	Joana	3	Name B8	Name C7	Joana	Name C4	Name A8	Value 3rd	# of 3rds	4	B5:B60	Hannah	3	6.00	Joana	3	4.00
6	Name A6	3	Name A6	Michael	Name C2	Joana	Name A9	3	5	5	B6:B60	Joana	3	4.00	Name A6	3	5.00
7	Name A7	1	Name C2	Name C1	Name B4	Name B3	Hannah	Value 4th	# of 4ths	6	B7:B60	Name A6	3	5.00	Hannah	3	6.00
8	Name A8	2	Name C8	Name C5	Michael	Michael	Name A6	2	9	25	B26:B60	Name C7	3	3.00	Diana	3	9.67
9	Name A9	1	Name C1	Name C2	Diana	Name C6	Name C2			8	B9:B60	Name A8	2	7.50	Name B2	2	2.00
10	Name B1	2	Name A8	Name B8	Hannah	Diana	Diana			10	B11:B60	Name B1	2	3.00	Name B9	2	2.50
11	Name B2	2	Name B2	Name B3	Name C8	Name B5	Joana			11	B12:B60	Name B2	2	2.00	Name B1	2	3.00
12	Name B3	1	Name A9	Diana	Ben	Name B4	Name B3			13	B14:B60	Name B4	2	5.50	Name C4	2	3.50
13	Name B4	2	Name C4	Name A8	Name A8	Name C7	Name C3			17	B18:B60	Name B8	2	7.50	Name B4	2	5.50
14	Name B5	0	Hannah	Name C4	Name B5	Name A8	Name B4			18	B19:B60	Name B9	2	2.50	Name C8	2	6.00
15	Name B6	0	Name C6	Name C8	Name B8	Name C9	Name B5			19	B20:B60	Name C1	2	8.00	Name A8	2	7.50
16	Name B7	1	Name B3	Name B7	Name A9	Name C1	Name C6			22	B23:B60	Name C4	2	3.50	Name B8	2	7.50
17	Name B8	2	Name C7	Name A9	Name B6	Name B9	Name C1			26	B27:B60	Name C8	2	6.00	Name C1	2	8.00
18	Name B9	2	Name A7	Name B2	Name B7	Ben	Name C5			7	B8:B60	Name A7	1	4.00	Name B7	1	1.00
19	Name C1	2	Name C5	Name C9	Name C1	Hannah	Ben			9	B10:B60	Name A9	1	6.00	Name A7	1	4.00
20	Name C2	5	Name C3	Name B5	Name B2	Name B7	Name B9			12	B13:B60	Name B3	1	7.00	Name C3	1	4.00
21	Name C3	1	Name B5	Joana	Name A7	Name A7	Name B1			16	B17:B60	Name B7	1	1.00	Name C9	1	4.00
22	Name C4	2	Name B7	Name B6	Name A6	Name A9	Name B6			21	B22:B60	Name C3	1	4.00	Name A9	1	6.00
23	Name C5	1	Diana	Ben	Name B3	Name B1	Name C9			23	B24:B60	Name C5	1	8.00	Name B3	1	7.00
24	Name C6	1	Name C9	Name B4	Name C6	Name B6	Name C4			24	B25:B60	Name C6	1	9.00	Name C5	1	8.00
25	Name C7	3	Ben	Name A6	Name C5	Name B8	Name B8			27	B28:B60	Name C9	1	4.00	Name C6	1	9.00
26	Name C8	2	Name B6	Name A7	Name B1	Name C3	Name C8			2	B3:B60	Ben	0	#DIV/0!	Ben	0	#DIV/0!
27	Name C9	1	Name B9	Name C6	Name C3	Name C5	Michael			14	B15:B60	Name B5	0	#DIV/0!	Name B5	0	#DIV/0!
28										15	B16:B60	Name B6	0	#DIV/0!	Name B6	0	#DIV/0!
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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