I'm trying to work out a formula for ranking but the data i need to rank contains a ton of ties. basically i have a 3 way tie for 1st, a 11 way tie for 2nd, a 8 way tie for 3rd, a 9 way tie for 4th, etc and its making my ranking look confusing. rather than the 4th place rank showing as "4", its returning 23 because there are 22 values ranked 1st through 3rd.
current rank
4
4
40
4
4
1
4
23
15
23
23
23
4
23
39
23
1
4
4
4
41
37
4
4
23
33
23
32
38
33
23
33
33
1
15
15
15
15
15
15
15
vs
what I would like
2
2
10
2
2
1
2
4
3
4
4
4
2
4
9
4
1
2
2
2
11
7
2
2
4
6
4
5
8
6
4
6
6
1
3
3
3
3
3
3
3
hopefully someone knows a solution for this. any help would be greatly appreciated.
current rank
4
4
40
4
4
1
4
23
15
23
23
23
4
23
39
23
1
4
4
4
41
37
4
4
23
33
23
32
38
33
23
33
33
1
15
15
15
15
15
15
15
vs
what I would like
2
2
10
2
2
1
2
4
3
4
4
4
2
4
9
4
1
2
2
2
11
7
2
2
4
6
4
5
8
6
4
6
6
1
3
3
3
3
3
3
3
hopefully someone knows a solution for this. any help would be greatly appreciated.
Last edited: