Tom and Rons Pools
New Member
- Joined
- Apr 23, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I have set up a ranking system for my category and then used a formula to assign each a point total. However the points are coming in reverse order.
Here is my spreadsheet and I will show the formulas below:
The rank is correct and here is the formula I used: =RANK(B2,$B$2:$B$13)
Here is the formula under root column but the points are assigning in the wrong order: =IF(COUNTIF($C$2:$C$13,C2)>1,((C2-1)+(C2+(COUNTIF($C$2:$C$13,C2))))/2,C2)
The points should be the person who has the most goals gets the 12 and so on.
Here is my spreadsheet and I will show the formulas below:
Team | Goals | Rank | Roto |
1 | 13 | 3 | 3.5 |
2 | 13 | 3 | 3.5 |
3 | 22 | 1 | 1 |
4 | 14 | 2 | 2 |
5 | 11 | 5 | 5 |
6 | 8 | 7 | 7 |
7 | 9 | 6 | 6 |
8 | 3 | 10 | 10.5 |
9 | 4 | 9 | 9 |
10 | 5 | 8 | 8 |
11 | 3 | 10 | 10.5 |
12 | 1 | 12 | 12 |
The rank is correct and here is the formula I used: =RANK(B2,$B$2:$B$13)
Here is the formula under root column but the points are assigning in the wrong order: =IF(COUNTIF($C$2:$C$13,C2)>1,((C2-1)+(C2+(COUNTIF($C$2:$C$13,C2))))/2,C2)
The points should be the person who has the most goals gets the 12 and so on.