I've downloaded some stats on Driving Distance from the PGA website - there's 217 players in the list. I now want to delete those players that aren't playing in this week's tournament. I have the entry list of players competing in the tournament in another column in the sheet. Any ideas on how to do this? For example:
Entry List | |||||||
RANK THIS WEEK | PLAYER First name | Surname | AVG. | TOTAL DISTANCE | TOTAL DRIVES | Surname | First name |
1 | Bryson | DeChambeau | 323 | 27134 | 84 | An | Byeong Hun |
2 | Cameron | Champ | 321.8 | 32177 | 100 | Ancer | Abraham |
3 | Ryan | Brehm | 314.7 | 27695 | 88 | Berger | Daniel |
4 | Grayson | Murray | 314.1 | 21360 | 68 | Bezuidenhout | Christiaan |
5 | Rory | McIlroy | 313.9 | 17581 | 56 | Blair | Zac |
6 | Bubba | Watson | 313.1 | 22541 | 72 | Bradley | Keegan |
7 | Matthew | Wolff | 312.6 | 26262 | 84 | Cabrera Bello | Rafa |
8 | Brandon | Hagy | 312.3 | 24980 | 80 | Cantlay | Patrick |
9 | Jason | Kokrak | 311.9 | 21831 | 70 | Casey | Paul |
10 | Sam | Burns | 311.1 | 29865 | 96 | Cauley | Bud |
11 | Scottie | Scheffler | 310.8 | 36054 | 116 | Champ | Cameron |
12 | Adam | Scott | 310.3 | 11172 | 36 | Choi | K.J. |
13 | Tyler | McCumber | 309.8 | 31598 | 102 | Cink | Stewart |
14 | Tommy | Fleetwood | 309.5 | 6189 | 20 | Clark | Wyndham |
15 | Brooks | Koepka | 308.4 | 13570 | 44 | Conners | Corey |
16 | Cameron | Davis | 308.3 | 28363 | 92 | Dahmen | Joel |
17 | Patrick | Rodgers | 308.1 | 46220 | 150 | Day | Jason |
18 | Jhonattan | Vegas | 308 | 25870 | 84 | DeChambeau | Bryson |
T19 | Gary | Woodland | 307.5 | 22143 | 72 | Dufner | Jason |
T19 | Lucas | Bjerregaard | 307.5 | 14147 | 46 | Duncan | Tyler |
21 | Byeong Hun | An | 307 | 28854 | 94 | Els | Ernie |
22 | Scott | Harrington | 306.8 | 34366 | 112 | English | Harris |
23 | Will | Gordon | 306.6 | 15944 | 52 | Finau | Tony |
T24 | Beau | Hossler | 306.3 | 36142 | 118 | Fitzpatrick | Matthew |
T24 | Dustin | Johnson | 306.3 | 15928 | 52 | Fowler | Rickie |
26 | Tony | Finau | 305.9 | 23250 | 76 | Frittelli | Dylan |
27 | Sergio | Garcia | 305.7 | 11006 | 36 | Furyk | Jim |