Ranking function problem

Sure (formula: =RANK.AVG(M2, M$2:M$81, 1)

10.16774725
15.72501801
1a)7.003190285
8.541730987
5.814551816
3.3446537
8.495420397
4.291447978
3.962128229
13.2088093
3.735720902
2.938149635
11.2071627
9.745806319
2a)3.720284038
6.55037563
7.893382731
10.51250386
6.884841
5.181640424
4.502418442
9.776680045
5.891736133
7.198723886
3a)2.078830915
5.619018215
7.636101677
4.806010085
4a)1.67232685
9.12833179
2.243490789
3.946691366
12.54502418
4.713388906
1.039415457
3.493876711
7.018627148
6.627559946
1.445919522
5.680765668
11.40269631
7.666975404
8.824740146
7.080374601
5.860862406
4.306884841
2b)3.720284038
3.056498919
5a)4.759699496
9.956776783
4.384069157
4.595039621
7.877945868
6.056396007
5.572707626
8.433672944
9.684058866
3.360090563
4.790573222
3.29834311
3b)2.078830915
3.58649789
1b)7.003190285
9.879592467
5.361737162
6.102706597
2.727179171
2.274364516
5.799114953
2.454461253
2.500771843
4b)1.67232685
5.768241227
2.094267778
4.15766183
5b)4.759699496
2.063394052
8.721827725
2.258927653
7.620664814


74
80
53
65
45
18
64
28
26
79
24
15
76
70
22
50
62
75
52
38
31
71
47
57
7
41
59
37
3
68
9
25
78
33
1
20
55
51
2
42
77
60
67
56
46
29
23
16
35
73
30
32
61
48
40
63
69
19
36
17
6
21
54
72
39
49
14
11
44
12
13
4
43
8
27
34
5
66
10
58

Sorry, not really sure how the formatting for tables worked. I hope that is clear enough.. (bolded = should have been averaged)