floridabill
New Member
- Joined
- Sep 13, 2018
- Messages
- 3
A3 =VLOOKUP(D3,DISPLAY!$B$4:$C$26,2,FALSE)
B3 =RANK.EQ(T3,$T$3:$T$25,0)+COUNTIFS($T$3:$T$25,T3,$A$3:$A$25,"<"&A3)
<tbody>
</tbody>
B3 =RANK.EQ(T3,$T$3:$T$25,0)+COUNTIFS($T$3:$T$25,T3,$A$3:$A$25,"<"&A3)
9/16/2018 | |||||||||||||||||||||||||
Handicap | Rank | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Points | NewRank | rank | rank w handicap | |||||||||
7 | 1 | 1 | Crall, Mike - w | 30 | 23 | 31 | 29 | 33 | 30 | 22 | 26 | 27 | 21 | 32 | 28 | 0 | 32 | 0 | 31.00 | 30.67 | 1 | 1 | - | ||
9 | 2 | 2 | Martin, Charles - w | 30 | 0 | 25 | 31 | 31 | 29 | 31 | 31 | 28 | 27 | 29 | 0 | 0 | 22 | 29 | 29.00 | 28.67 | 2 | 2 | 2 | ||
14 | 3 | 3 | Knott, Bill - g | 26 | 24 | 24 | 24 | 27 | 25 | 24 | 27 | 28 | 24 | 29 | 0 | 0 | 27 | 24 | 28.00 | 28.00 | 3 | 3 | 3 | ||
25 | 18 | 18 | Rollins, Dan - w | 18 | 24 | 25 | 21 | 23 | 18 | 20 | 24 | 25 | 19 | 23 | 16 | 0 | 19 | 16 | 20.00 | 20.33 | 18 | 18 | 18 |
<tbody>
</tbody>