Spreadsheet: 792444d1660908440-formula-with-multiple-matches-training-example-v2
Sheet: Raw Data

Type | Trainer | Location | Location | Location |  | Type drop down |  | Training Locations |  | Car | Motorcycle | LGV | Vehicle | [NAME]
Car | [NAME] | Slough | Slough | Slough |  | Car |  | Aberdeen N |  | New Entrant - Driver Development York | M/C Examiner | LGV FAM & B+E
Car | [NAME] | All | All | All |  | Motorcycle |  | Avonmouth |  | New Entrant - Driver Development Shrewbury | M/C Examiner | LGV Assessments
Car | [NAME] | Leeds (Hillcrest House) | Gosforth | [NAME] |  | LGV |  | Bedford DTC |  | New Entrant - Driver Development Brentwood | MC Car 2 Bike | LGV OSI BRIEFING
Car | Clive Barber | All | All | All |  | Vehicle |  | [NAME] ([NAME]) |  | New Entrant - Driver Development Dundee | M/C Assessment | [NAME]
Car | [NAME] | Leeds (Hillcrest House) | Gosforth | Gosforth |  | [NAME] |  | Beverley |  | New Entrant - Driver Development Garretts Green | MC [NAME] | Licence Acquisition Pt 1  SP Training
Car | [NAME] | All | All | All |  |  |  | [NAME] |  | New Entrant - Driver Development Slough | M/C Development | Licence Acquisition Pt 1 [NAME]
Car | [NAME] | Brentwood | Slough | Farnborough |  | Type of Leave |  | Brentwood |  | New Entrant - Driver Development Chadderton | [NAME] | Licence Acquisition Pt 1 RTITB -CAT C
Car | [NAME] | Chadderton | Chadderton | Chadderton |  | AL |  | Cambridge |  | New Entrant - Slough | Mod 1 M/C Course | Licence Acquisition Pt 1 [NAME] -CAT C+E
Car | [NAME] | All | All | All |  | Training |  | Chadderton |  | New Entrant - Norwich | Mod 1 Supervision | Licence Acquisition Pt 1 RTITB -CAT D
Car | [NAME] | All | All | All |  | Development Day |  | Farnborough |  | New Entrant - Chadderton | Mod 1/2 QC | LGV/PCV Examiner Training 4
Car | [NAME] | [NAME] | [NAME] | [NAME] |  | Personal |  | Garretts Green |  | New Entrant -  Garretts Green | ERS (Enchanced Rider Scheme) | LGV/PCV Examiner Training - CPC
Car | [NAME] | All | All | All |  |  |  | [NAME] |  | New Entrant - Cambridge | M/C Taster Development Week | LGV Examiner Training QA Team
Car | [NAME] | All | All | All |  |  |  | Gosforth |  | New Entrant - Bishopbriggs | MC Training Specialist Briefing | LGV Supervision
Car | [NAME] | All | All | All |  | Date of training |  | [NAME] |  | New Entrant - Gosforth |  | D + D1
Car | [NAME] | Gosforth | Gosforth | Gosforth |  | August |  | Leeds (Hillcrest House) |  | New Entrant - Avonmouth |  | C + E
Car | Jan Nascimento | All | All | All |  | September |  | Llantrisant |  | New Entrant - Trial |  | D1 +E
Car | [NAME] | [NAME] | Slough | Slough |  | October |  | [NAME] |  | New Entrant - Beverley |  | B+E
Car | [NAME] | All | All | All |  | November |  | Plymouth |  | New Entrant - Brentwood
Car | [NAME] | All | All | All |  | December |  | Portsmouth |  | New Entrant - Farnborough
Car | [NAME] | All | All | All |  | January |  | Slough |  | New Entrant - Leeds
Car | [NAME] | Plymouth | Plymouth | Plymouth |  | February |  | All |  | New Entrant - Llantrisant
Car | [NAME] | All | All | All |  | March |  |  |  | Driving Examiner CPD - Cardington
Car | [NAME] | All | All | All |  |  |  |  |  | Driving Examiner CPD - Local
Car | [NAME] | All | All | All |  |  |  |  |  | CPD  - Enforcement
Car | [NAME] | All | All | All |  |  |  |  |  | Driving Examiner CPD - Mopup Local
Car | [NAME] | Brentwood | Cambridge | Slough |  |  |  |  |  | LDTM - CPD
Car | [NAME] | All | All | All |  |  |  |  |  | Vocational Examiner CPD - LGV/PCV
Car | [NAME] | All | All | All |  |  |  |  |  | Training Specialst Assessments
Car | [NAME] | All | All | All |  |  |  |  |  | PSI - TS Briefing - Garretts Green
Car | [NAME] | All | All | All |  |  |  |  |  | OSI - TS Briefing - Garretts Green
Car | [NAME] | All | All | All |  |  |  |  |  | OSI - TS Briefing -
Car | [NAME] | All | All | All |  |  |  |  |  | OSI - TS Briefing - Gosforth
Car | [NAME] | All | All | All |  |  |  |  |  | OSI - TS Briefing - Garretts Green
Car | [NAME] | Slough | Avonmouth | Cambridge |  |  |  |  |  | OSI - TS Briefing MC -
Car | [NAME] | All | All | All |  |  |  |  |  | Train the Trainer
Car | [NAME] | Farnborough | Farnborough | Farnborough |  |  |  |  |  | LDTM Train the Trainer
Car | Clare Hazelwood | All | All | All |  |  |  |  |  | LDTM Train the Trainer
Car | [NAME] | All | All | All |  |  |  |  |  | OSI - Refresher
Car | [NAME] | All | All | All |  |  |  |  |  | DE Refresher
Car | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  | Interpersonal Skills
Car | [NAME] | All | All | All |  |  |  |  |  | DE Assessment
Car | [NAME] | All | All | All |  |  |  |  |  | NE In Field Assessment
Car | [NAME] Senior | All | All | All |  |  |  |  |  | NE Mentor training
Car | [NAME] | All | All | All |  |  |  |  |  | [NAME]
Car | [NAME] | All | All | All |  |  |  |  |  | [NAME]
Car | [NAME] | Cambridge | Cambridge | Cambridge |  |  |  |  |  | [NAME]
Car | [NAME] | Cambridge | Cambridge | Cambridge |  |  |  |  |  | LDTM Mod B Data analysis and MI
Car | [NAME] | All | All | All |  |  |  |  |  | [NAME] and Performance
Car | [NAME] | All | All | All |  |  |  |  |  | Two Day LDTM In-Field Assessment
Car | [NAME] | All | All | All |  |  |  |  |  | LDTM Development
Car | [NAME] | All | All | All |  |  |  |  |  | LDTM test/supervision ne DEs
Car | [NAME] | All | All | All
Car | [NAME] | All | All | All
Car | [NAME] | All | All | All
LGV | [NAME] | All | All | All
LGV | [NAME] | All | All | All
LGV | [NAME] | All | All | All
LGV | [NAME] | [NAME] | Slough | Slough
LGV | [NAME] | Plymouth | Plymouth | Plymouth
LGV | [NAME] | All | All | All
LGV | [NAME] | All | All | All
LGV | [NAME] | All | All | All
LGV | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All
Motorcycle | [NAME] | All | All | All