Spreadsheet: 160818d1339221514-help-match-two-columns-with-different-criteria-runners
Sheet: Entries

Ent | Reg | Last | First | Event Type | Payment amount | Type
1 | 1 | Cunningham | Carol | Short Course Series | [NAME] | Participant
2 | 2 | Crow | Jacquelene | Short Course Series | [NAME] | Participant
3 | 3 | [NAME] | Emma | Short Course Series | [NAME] | Participant
4 | 4 | Trist | Meagan | Short Course Series | AU$240.00 | trailsplus
5 | 5 | Saxon | [NAME] | Short Course Series | AU$0.00 | Participant
6 | 6 | [NAME] | Stu | Short Course Series | [NAME] | Participant
7 | 7 | [NAME] | Carolyn | Short Course Series | [NAME] | Participant
8 | 8 | Noy | Nicole | Short Course Series | [NAME] | Participant
9 | 9 | Mooney | Lana | Short Course Series | AU$0.00 | Participant
10 | 10 | Luckeraft | Adam | Short Course Series | [NAME] | Participant
11 | 11 | Jakus | Gabor | Short Course Series | [NAME] | Participant
12 | 12 | [NAME] | [NAME] | Short Course Series  (3Races) | [NAME] | Participant
13 | 301 | [NAME] | Ang | 30km Series Entry (4Races) Non Member | AU$60.00 | trailsplus
14 | 302 | [NAME] | Yvonne | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
15 | 303 | Tyrrell | [NAME] | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
16 | 304 | [NAME] | Brian | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
17 | 305 | [NAME] | Henrik | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
18 | 306 | [NAME] | Lauren | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
19 | 307 | Smythe | David | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
20 | 308 | [NAME] | [NAME] | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
21 | 309 | Noall | [NAME] | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
22 | 310 | Kinsella | [NAME] | 30km Series Entry (4Races) Non Member | AU$240.00 | Participant
23 | 311 | [NAME] | [NAME] | 30km Series Entry (4Races) AURA Member | AU$50.00 | trailsplus
24 | 312 | Cowan | Alistair | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
25 | 313 | Cheong | [NAME] | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
26 | 314 | [NAME] | [NAME] | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
27 | 315 | Burns | Elise | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
28 | 316 | Peden | Grant | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
29 | 317 | [NAME] | [NAME] | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
30 | 318 | Hoad | [NAME] | 30km Series Entry (4Races) AURA Member | AU$200.00 | Participant
31 | 319 | [NAME] | Russell | 30km Series Entry (3Races) Non Member | [NAME] | Participant
32 | 320 | Proctor | Brian | 30km Series Entry (3Races) Non Member | [NAME] | Participant
33 | 321 | Fahey | [NAME] | 30km Series Entry (3Races) Non Member | [NAME] | Participant
34 | 322 | [NAME] | [NAME] | 30km Series Entry (3Races) Non Member | [NAME] | Participant
35 | 501 | Emmerson | [NAME] | 50km Series Entry (4Races) Non AURA Member | AU$80.00 | trailsplus
36 | 502 | Crozier | [NAME] | 50km Series Entry (4Races) Non AURA Member | AU$300.00 | Participant
37 | 503 | [NAME] | Dom | 50km Series Entry (4Races) Non AURA Member | AU$300.00 | Participant
38 | 504 | [NAME] | Glenn | 50km Series Entry (4Races) Non AURA Member | AU$300.00 | Participant
39 | 505 | Watts | David | 50km Series Entry (4Races) Non AURA Member | AU$80.00 | trailsplus
40 | 506 | Rogers | David | 50km Series Entry (4Races) Non AURA Member | AU$300.00 | Participant
41 | 507 | Meyer | Bernd | 50km Series Entry (4Races) Non AURA Member | AU$300.00 | Participant
42 | 508 | [NAME] | Stuart | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
43 | 509 | Wiadrowski | Toby | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
44 | 510 | [NAME] | Kerryn | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
45 | 511 | Bignell | [NAME] | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
46 | 512 | [NAME] | John | 50km Series Entry (4Races) AURA Member | AU$70.00 | trailsplus
47 | 513 | Lavoie | [NAME] | 50km Series Entry (4Races) AURA Member | AU$70.00 | trailsplus
48 | 514 | Kift | [NAME] | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
49 | 515 | Jenkins | [NAME] | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
50 | 516 | [NAME] | [NAME] | 50km Series Entry (4Races) AURA Member | [NAME] | Participant
51 | 517 | Beard | [NAME] | 50km Series Entry (4Races) AURA Member | AU$70.00 | trailsplus
52 | 518 | Kinder | [NAME] | 50km Series Entry (3Races) AURA Member | AU$255.00 | Confirmed
53 | 519 | Attard | [NAME] | CANCELLED | -AU$260.00 | Canceled
54 | 801 | Gladwell | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
55 | 802 | Barker | Nicole | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
56 | 803 | Evans | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
57 | 804 | Drummond | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
58 | 805 | Vlachos | Theo | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
59 | 806 | Mitchell | Scott | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
60 | 807 | [NAME] | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | trailsplus
61 | 808 | Macmillan | Katherine | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
62 | 809 | [NAME] | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
63 | 810 | [NAME] | Derek | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
64 | 811 | Jones | Brian | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
65 | 812 | [NAME] | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
66 | 813 | Hall | [NAME] | Ultra Series (50k,50km,80k,100k) | AU$300.00 | Participant
67 | 814 | Esparon | [NAME] | Ultra Series (50k,50km,80k,100k) Non Member | AU$350.00 | Participant
68 | 815 | Cowling | Gayle | Ultra Series (50k,50km,80k,100k) Non Member | AU$350.00 | Participant
69 | 816 | Corner | Stephen | Ultra Series (50k,50km,80k,100k) Non Member | AU$350.00 | Participant
70 | 817 | [NAME] | [NAME] | Ultra Series (50k,50km,80k,100k) Non Member | AU$350.00 | Participant
71 | 818 | Muller | [NAME] | Ultra Series (50km,80k,100k) | AU$85.00 | trailsplus
72 | 819 | Sutton | [NAME] | Ultra Series (50km,80k,100k) | AU$315.00 | Participant