Hi There,
My Rank formula isn't working properly and I'm not getting the proper results.
I don't mind duplicates which i can fix with some weighted adjustments.
I'm getting dupes with different point values which has me baffled.
Here's my formula: =IFERROR(RANK(AS3,AS3:AS104,0),"")
I'm new at Rank and am assuming I'm doing something really wrong here:
(Note: Totals is column AS)
<colgroup><col><col></colgroup><tbody>
</tbody>
My Rank formula isn't working properly and I'm not getting the proper results.
I don't mind duplicates which i can fix with some weighted adjustments.
I'm getting dupes with different point values which has me baffled.
Here's my formula: =IFERROR(RANK(AS3,AS3:AS104,0),"")
I'm new at Rank and am assuming I'm doing something really wrong here:
(Note: Totals is column AS)
RANK | Totals |
97 | 8 |
74 | 14 |
55 | 19 |
55 | 19 |
21 | 33 |
48 | 20 |
27 | 30 |
1 | 57 |
55 | 18 |
45 | 21 |
59 | 17 |
65 | 14 |
86 | 7 |
38 | 25 |
49 | 19 |
38 | 25 |
20 | 33 |
26 | 29 |
76 | 10 |
57 | 15 |
46 | 19 |
70 | 11 |
75 | 9 |
76 | 7 |
73 | 10 |
46 | 19 |
41 | 20 |
21 | 32 |
11 | 41 |
20 | 32 |
29 | 27 |
23 | 29 |
57 | 12 |
19 | 33 |
40 | 18 |
40 | 18 |
39 | 19 |
32 | 22 |
57 | 11 |
32 | 22 |
48 | 13 |
50 | 12 |
48 | 13 |
33 | 20 |
9 | 43 |
32 | 20 |
8 | 44 |
7 | 45 |
32 | 18 |
51 | 7 |
4 | 48 |
23 | 27 |
32 | 17 |
12 | 37 |
7 | 41 |
42 | 11 |
14 | 31 |
15 | 29 |
8 | 39 |
25 | 18 |
21 | 23 |
33 | 12 |
13 | 30 |
9 | 38 |
12 | 28 |
19 | 20 |
6 | 43 |
8 | 36 |
13 | 27 |
20 | 15 |
13 | 26 |
24 | 12 |
9 | 32 |
1 | 57 |
22 | 12 |
26 | 5 |
23 | 11 |
13 | 20 |
20 | 13 |
20 | 12 |
6 | 39 |
10 | 24 |
11 | 18 |
6 | 34 |
2 | 53 |
4 | 41 |
8 | 17 |
4 | 28 |
9 | 14 |
4 | 28 |
1 | 54 |
10 | 9 |
3 | 28 |
2 | 46 |
1 | 48 |
3 | 15 |
3 | 14 |
1 | 22 |
2 | 14 |
3 | 1 |
1 | 16 |
1 | 10 |
<colgroup><col><col></colgroup><tbody>
</tbody>