Spreadsheet: 47643d1246764083-how-to-sort-the-ladder-using-correct-functions-league-results-help
Sheet: Week5

League Standings after Week 5 (Unsorted)
Bowler No | Team Standings | Won | Won | Scratch | W/HCP | Game | Series | Game | Series | Gender | Sorter | Rank | DupCount | Rank2
1 | [NAME] | 3 | 33 | 2398 | 2884 | 194 | 526 | 229 | 634 | F | 3302884 | 1 | 1 | 1
2 | [NAME] | 6 | 31 | 2308 | 2926 | 194 | 485 | 233 | 626 | F | 3102926 | 3 | 1 | 3
3 | [NAME] | 7 | 29 | 1997 | 2900 | 177 | 445 | 234 | 631 | M | 2902900 | 6 | 1 | 6
4 | Glenda S | 5 | 19 | 2089 | 2263 | 212 | 576 | 235 | 645 | F | 1902263 | 22 | 1 | 22
5 | [NAME] | 10 | 31 | 2374 | 2917 | 211 | 542 | 249 | 656 | M | 3102917 | 4 | 1 | 4
6 | [NAME] | 4 | 26 | 2438 | 2870 | 190 | 512 | 218 | 608 | M | 2602870 | 13 | 1 | 13
7 | [NAME] | 0 | 14 | 1063 | 2098 | 113 | 318 | 208 | 603 | F | 1402098 | 25 | 1 | 25
8 | [NAME] | 0 | 7 | 1014 | 1635 | 129 | 349 | 201 | 565 | F | 701635 | 28 | 1 | 28
9 | [NAME] | 0 | 7 | 1410 | 1647 | 181 | 503 | 206 | 578 | F | 701647 | 27 | 1 | 27
10 | [NAME] | 10 | 28 | 1861 | 2812 | 180 | 458 | 247 | 659 | F | 2802812 | 7 | 1 | 7
11 | [NAME] | 4 | 23 | 1937 | 2780 | 164 | 406 | 221 | 580 | M | 2302780 | 19 | 1 | 19
12 | [NAME] | 4.5 | 16.5 | 1967 | 2336 | 221 | 542 | 258 | 653 | M | 1652336 | 24 | 1 | 24
13 | [NAME] | 3 | 27 | 2123 | 2756 | 174 | 474 | 217 | 603 | F | 2702756 | 11 | 1 | 11
14 | [NAME] | 9 | 17 | 1630 | 2683 | 142 | 360 | 213 | 570 | F | 1702683 | 23 | 1 | 23
15 | Fred J | 0 | 25 | 2071 | 2362 | 206 | 552 | 237 | 645 | M | 2502362 | 15 | 1 | 15
16 | [NAME] | 3 | 19 | 2174 | 2345 | 212 | 577 | 226 | 623 | F | 1902345 | 21 | 1 | 21
17 | [NAME] | 1 | 20 | 2622 | 2910 | 202 | 556 | 223 | 628 | M | 2002910 | 20 | 1 | 20
18 | Syvlia G | 8 | 24 | 1899 | 2280 | 182 | 497 | 214 | 593 | F | 2402280 | 18 | 1 | 18
19 | [NAME] | 2 | 31 | 2441 | 2864 | 190 | 524 | 225 | 607 | M | 3102864 | 5 | 1 | 5
20 | [NAME] | 7 | 27 | 2362 | 2878 | 199 | 530 | 236 | 650 | M | 2702878 | 10 | 1 | 10
21 | [NAME] | 7 | 26 | 1453 | 2704 | 152 | 340 | 238 | 598 | F | 2602704 | 14 | 1 | 14
22 | [NAME] | 0 | 14 | 1659 | 1722 | 231 | 581 | 239 | 605 | M | 1401722 | 26 | 1 | 26
23 | [NAME] | 7.5 | 27.5 | 2381 | 2843 | 197 | 517 | 227 | 607 | M | 2752843 | 8 | 1 | 8
24 | Xavier R | 10 | 33 | 2068 | 2851 | 177 | 460 | 232 | 616 | M | 3302851 | 2 | 1 | 2
25 | [NAME] | 1 | 24 | 2082 | 2820 | 183 | 480 | 238 | 645 | M | 2402820 | 16 | 1 | 16
26 | [NAME] T | 0 | 24 | 1537 | 2284 | 153 | 441 | 217 | 633 | F | 2402284 | 17 | 1 | 17
27 | [NAME] | 3 | 27 | 2606 | 2903 | 219 | 573 | 239 | 642 | F | 2702903 | 9 | 1 | 9
28 | Ashleigh K | 5 | 26 | 2322 | 2916 | 198 | 549 | 245 | 690 | F | 2602916 | 12 | 1 | 12
League Standings after Week 5 (Sorted by Total Poins Won then Total Pinfall W/HCP)
 |  | Match | Total | Total | Total | High | High | High | High
 |  | Points | Points | Pinfall | Pinfall | Scratch | Scratch | Handicap | Handicap
Position | Team Standings | Won | Won | Scratch | W/HCP | Game | Series | Game | Series | Bowler No | Gender |  | Row
1 | [NAME] | 3 | 33 | 2398 | 2884 | 194 | 526 | 229 | 634 | F | 3302884 |  | 1
2 | Xavier R | 10 | 33 | 2068 | 2851 | 177 | 460 | 232 | 616 | M | 3302851 |  | 24
3 | [NAME] | 6 | 31 | 2308 | 2926 | 194 | 485 | 233 | 626 | F | 3102926 |  | 2
4 | [NAME] | 10 | 31 | 2374 | 2917 | 211 | 542 | 249 | 656 | M | 3102917 |  | 5
5 | [NAME] | 2 | 31 | 2441 | 2864 | 190 | 524 | 225 | 607 | M | 3102864 |  | 19
6 | [NAME] | 7 | 29 | 1997 | 2900 | 177 | 445 | 234 | 631 | M | 2902900 |  | 3
7 | [NAME] | 10 | 28 | 1861 | 2812 | 180 | 458 | 247 | 659 | F | 2802812 |  | 10
8 | [NAME] | 7.5 | 27.5 | 2381 | 2843 | 197 | 517 | 227 | 607 | M | 2752843 | [NAME] | 23
9 | [NAME] | 3 | 27 | 2606 | 2903 | 219 | 573 | 239 | 642 | F | 2702903 |  | 27
10 | [NAME] | 7 | 27 | 2362 | 2878 | 199 | 530 | 236 | 650 | M | 2702878 |  | 20
11 | [NAME] | 3 | 27 | 2123 | 2756 | 174 | 474 | 217 | 603 | F | 2702756 |  | 13
12 | Ashleigh K | 5 | 26 | 2322 | 2916 | 198 | 549 | 245 | 690 | F | 2602916 |  | 28
13 | [NAME] | 4 | 26 | 2438 | 2870 | 190 | 512 | 218 | 608 | M | 2602870 |  | 6
14 | [NAME] | 7 | 26 | 1453 | 2704 | 152 | 340 | 238 | 598 | F | 2602704 |  | 21
15 | Fred J | 0 | 25 | 2071 | 2362 | 206 | 552 | 237 | 645 | M | 2502362 |  | 15
16 | [NAME] | 1 | 24 | 2082 | 2820 | 183 | 480 | 238 | 645 | M | 2402820 |  | 25
17 | [NAME] T | 0 | 24 | 1537 | 2284 | 153 | 441 | 217 | 633 | F | 2402284 |  | 26
18 | Syvlia G | 8 | 24 | 1899 | 2280 | 182 | 497 | 214 | 593 | F | 2402280 |  | 18
19 | [NAME] | 4 | 23 | 1937 | 2780 | 164 | 406 | 221 | 580 | M | 2302780 |  | 11
20 | [NAME] | 1 | 20 | 2622 | 2910 | 202 | 556 | 223 | 628 | M | 2002910 |  | 17
21 | [NAME] | 3 | 19 | 2174 | 2345 | 212 | 577 | 226 | 623 | F | 1902345 |  | 16
22 | Glenda S | 5 | 19 | 2089 | 2263 | 212 | 576 | 235 | 645 | F | 1902263 |  | 4
23 | [NAME] | 9 | 17 | 1630 | 2683 | 142 | 360 | 213 | 570 | F | 1702683 |  | 14
24 | [NAME] | 4.5 | 16.5 | 1967 | 2336 | 221 | 542 | 258 | 653 | M | 1652336 | [NAME] | 12
25 | [NAME] | 0 | 14 | 1063 | 2098 | 113 | 318 | 208 | 603 | F | 1402098 |  | 7
26 | [NAME] | 0 | 14 | 1659 | 1722 | 231 | 581 | 239 | 605 | M | 1401722 |  | 22
27 | [NAME] | 0 | 7 | 1410 | 1647 | 181 | 503 | 206 | 578 | F | 701647 |  | 9
28 | [NAME] | 0 | 7 | 1014 | 1635 | 129 | 349 | 201 | 565 | F | 701635 |  | 8