Spreadsheet: 780190d1652342504-data-sort-solution-needed-please-excelforum-sample
Sheet: desired result

NO | DATE | TEAM NAME | DIV NO | PLAYER NO | HCP | NAME | RANKING | GROSS | NETT | RESULT
4 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 4 | 24 | [NAME] | 60 | 96 | 72 | 2ND
5 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 5 | 21 | [NAME] | 61 | 98 | 77
8 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 8 | 19 | Cliff | 70 | 93 | 74
2 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 2 | 10 | [NAME] | 84 | 90 | 80
7 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 7 | 13 | Tim | 87 | 77 | 64 | WON
6 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 6 | 11 | [NAME] | 88 | 86 | 75
1 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 1 | 5 | [NAME] | 94 | 80 | 75 | 4TH
3 | 2022-04-10 00:00:00 | MEN AT WORK | 1 | 3 | 2 | [NAME] | 100 | 75 | 73 | 3RD
10 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 2 | 25 | Ned | 64 | 99 | 74 | 4TH
9 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 1 | 11 | [NAME] | 81 | 90 | 79
14 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 6 | 12 | [NAME] | 84 | 90 | 78
15 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 7 | 15 | [NAME] | 86 | 84 | 69 | 3RD
13 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 5 | 6 | [NAME] | 98 | 73 | 67 | WON
12 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 4 | 4 | Fred | 100 | 72 | 68 | 2ND
11 | 2022-04-10 00:00:00 | LOW NUMBERS | 2 | 3 |  | [NAME] |  | 100 | 100
18 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 3 | 27 | Byron | 58 | 99 | 72 | 3RD
17 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 2 | 22 | [NAME] | 73 | 99 | 77 | 4TH
19 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 4 | 11 | Harold | 81 | 90 | 79
20 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 5 | 16 | [NAME] | 87 | 85 | 69 | WON
21 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 6 | 6 | [NAME] | 98 | 78 | 72
16 | 2022-04-10 00:00:00 | HOT SHOTS | 3 | 1 | 3 | [NAME] | 100 | 74 | 71 | 2ND
29 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 8 | 26 | [NAME] | 61 | 99 | 73 | 3RD
27 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 6 | 23 | Martin | 71 | 95 | 72 | 2ND
25 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 4 | 22 | Mark | 75 | 99 | 77
23 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 2 | 12 | [NAME] | 81 | 97 | 85
24 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 3 | 13 | [NAME] | 82 | 88 | 75 | 4TH
28 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 7 | 17 | Archie | 87 | 85 | 68 | WON
22 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 1 | 8 | [NAME] | 91 | 85 | 77
26 | 2022-04-10 00:00:00 | BACK TO BASICS | 1 | 5 | 1 | Victor | 100 | 75 | 74
38 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 6 | 25 | [NAME] | 68 | 99 | 74
36 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 4 | 22 | Clint | 71 | 96 | 74
35 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 3 | 24 | [NAME] | 76 | 89 | 65 | WON
33 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 1 | 16 | [NAME] | 83 | 89 | 73
37 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 5 | 18 | [NAME] | 86 | 84 | 66 | 2ND
40 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 8 | 11 | Christian | 88 | 14 | 3
39 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 7 | 7 | Tyson | 95 | 74 | 67 | 3RD
34 | 2022-04-10 00:00:00 | PUTTSTERS | 3 | 2 | 2 | [NAME] | 100 | 71 | 69 | 4TH
43 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 4 | 27 | [NAME] | 66 | 99 | 72 | 3RD
42 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 2 | 24 | Sid | 77 | 97 | 73 | 4TH
44 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 5 | 12 | [NAME] | 80 | 88 | 76
46 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 7 | 14 | Troy | 81 | 84 | 70 | WON
41 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 1 | 14 | Geoff | 82 | 85 | 71 | 2ND
45 | 2022-04-10 00:00:00 | LONG DRIVERS | 2 | 6 | 9 | Bernard | 90 | 89 | 80