Spreadsheet: 117355d1312713309-excel-2008-almost-solved-vlookup-offset-match-and-countif-copy-of-student-records-and-database
Sheet: Dive Codes

CODE | [NAME] | Description | Qualification Type
A01 | Open Water Lesson | Diving And Rescue Skills Review | Advanced Diver
A02 | Open Water Lesson | Rescue Kills An Management Review | Advanced Diver
ADVBQ1 |  |  | Advanced Diver
ADVBQ10 |  |  | Advanced Diver
[NAME] |  |  | Advanced Diver
ADVBQ3 |  |  | Advanced Diver
ADVBQ4 |  |  | Advanced Diver
ADVBQ5 |  |  | Advanced Diver
ADVBQ6 |  |  | Advanced Diver
ADVBQ7 |  |  | Advanced Diver
ADVBQ8 |  |  | Advanced Diver
ADVBQ9 |  |  | Advanced Diver
ADVD01 |  | Planned Decompression Dive (1) | Advanced Diver
ADVD02 |  | Planned Decompression Dive (2) | Advanced Diver
ADVD03 |  | Planned Decompression Dive (3) | Advanced Diver
ADVD04 |  | Dive In Tidal Waters (1) | Advanced Diver
ADVD05 |  | Dive In Tidal Waters (2) | Advanced Diver
ADVD06 |  | Dive In Tidal Waters (3) | Advanced Diver
ADVD07 |  | Drift Dive (1) | Advanced Diver
ADVD08 |  | Drift Dive (2) | Advanced Diver
ADVD09 |  | Drift Dive (3) | Advanced Diver
ADVDAHOC1 |  |  | Advanced Diver
ADVDAHOC2 |  |  | Advanced Diver
ADVDAHOC3 |  |  | Advanced Diver
ADVDAHOC4 |  |  | Advanced Diver
ADVDAHOC5 |  |  | Advanced Diver
ADVDAHOC6 |  |  | Advanced Diver
ADVDE1 |  |  | Advanced Diver
ADVDE2 |  |  | Advanced Diver
ADVDE3 |  |  | Advanced Diver
ADVDE4 |  |  | Advanced Diver
ADVDE5 |  |  | Advanced Diver
ADVDE6 |  |  | Advanced Diver
ADVDL1 |  |  | Advanced Diver
ADVDL10 |  |  | Advanced Diver
ADVDL2 |  |  | Advanced Diver
ADVDL3 |  |  | Advanced Diver
ADVDL4 |  |  | Advanced Diver
ADVDL5 |  |  | Advanced Diver
ADVDL6 |  |  | Advanced Diver
[NAME] |  |  | Advanced Diver
[NAME] |  |  | Advanced Diver
ADVDL9 |  |  | Advanced Diver
ADVDM2D |  |  | Advanced Diver
[NAME] |  |  | Advanced Diver
ADVDMKUS2 |  |  | Advanced Diver
ADVDMUS1 |  |  | Advanced Diver
[NAME] |  |  | Advanced Diver
ADVTH01 |  | Theory Assessment | Advanced Diver
AP1 | Dry Practical Lesson | Expedition Planning | Advanced Diver
AP2 | Dry Practical Lesson | Dive Marshalling And Planning | Advanced Diver
AT1 | [NAME] | The Role Of The Advanced Diver | Advanced Diver
AT2 | [NAME] | Advanced Diving | Advanced Diver
AT3 | [NAME] | Organising Diving From Different Platforms | Advanced Diver
AT4 | [NAME] | Review Of Diving Conditions And On Site First Aid | Advanced Diver
Award1 |  | Assistant Diving Instructor | Award
Award2 |  | Assistant Open Water Instructor | Award
Award3 |  | Theory Instructor | Award
Award4 |  | Practical Instructor | Award
Award5 |  | Open water Instructor | Award
Award6 |  | Assistance Advanced Instructor | Award
Award7 |  | Advanced Instructor | Award
Award8 |  | First Class Diver | Award
Award9 |  | National Instructor | Award
D05 | Open Water Lesson | Rescue Management Scenarios | Dive Leader
D06 | Open Water Lesson | Diving And Rescue Skills Review | Dive Leader
DL01 |  | Planned Decompression Dive | Dive Leader
DL02 |  | [NAME] | Dive Leader
[NAME] |  | Low [NAME] | Dive Leader
DL04 |  | Night Dive | Dive Leader
DL05 |  | [NAME] | Dive Leader
DL06 |  | Drift Dive | Dive Leader
DL07 |  | Wall Dive | Dive Leader
DL08 |  | Minimum Of Twenty Dives/600 Minutes Confirmed Since Qualifying As Sports Diver | Dive Leader
DLBQ1 |  | Dive Leader Boat Dives | Dive Leader
DLBQ2 |  |  | Dive Leader
DLBQ3 |  |  | Dive Leader
DLBQ4 |  |  | Dive Leader
DLBQ5 |  |  | Dive Leader
DLBQ6 |  |  | Dive Leader
DLD25M1 |  |  | Dive Leader
DLD25M10 |  |  | Dive Leader
DLD25M2 |  |  | Dive Leader
DLD25M3 |  |  | Dive Leader
DLD25M4 |  |  | Dive Leader
DLD25M5 |  |  | Dive Leader
DLD25M6 |  |  | Dive Leader
DLD25M7 |  |  | Dive Leader
DLD25M8 |  |  | Dive Leader
DLD25M9 |  |  | Dive Leader
DLLQ1 |  | Dive Leader Leading | Dive Leader
DLLQ2 |  |  | Dive Leader
[NAME] |  |  | Dive Leader
DLLQ4 |  |  | Dive Leader
DLLQ5 |  |  | Dive Leader
DLLQ6 |  |  | Dive Leader
DLPQE1 |  | Depth Progression - 40m | Dive Leader
DLPQE2 |  | Depth Progression - 45m | Dive Leader
DLPQE3 |  | Depth Progression - 50m | Dive Leader
DLTA |  | Theory Assessment | Dive Leader
DO1 | Open Water Lesson | DSMB Use | Dive Leader
DO2 | Open Water Lesson | Dive Leading Demonstration | Dive Leader
DO3 | Open Water Lesson | Dive Leading Practice | Dive Leader
DO4 | Open Water Lesson | Shot Recovery By Simple Lift | Dive Leader
DO7 | Open Water Lesson | Rescue Skills Review | Dive Leader
DP1 | Dry Practical Lesson | Dive Marshalling 1 | Dive Leader
DP2 | Dry Practical Lesson | Dive Marshalling 2 | Dive Leader
DT1 | [NAME] | The Role Of The Dive Leader | Dive Leader
DT10 | [NAME] | Helicopter Operations | Dive Leader
DT11 | [NAME] | Rescue Management Part 2 | Dive Leader
DT12 | [NAME] | The Role Of The Dive Marshal | Dive Leader
DT2 | [NAME] | Cardio Pulmonary Resuscitation | Dive Leader
DT3 | [NAME] | Oxygen And Diving Incidents | Dive Leader
DT4 | [NAME] | Casualty Assessment | Dive Leader
DT5 | [NAME] | Oxygen Administration Equipment | Dive Leader
DT6 | [NAME] | Oxygen Administration In Practice | Dive Leader
DT7 | [NAME] | Use Of Oxygen Administration Equipment | Dive Leader
DT8 | [NAME] | Diving Planning | Dive Leader
DT9 | [NAME] | Rescue Management Part 1 | Dive Leader
OD01 |  | Shelving Shore Dive | Ocean Diver
OD02 |  | Steep Shore Dive | Ocean Diver
OD03 |  | Low [NAME] | Ocean Diver
OD04 |  | Drift Dive | Ocean Diver
OD05 |  | Small Boat Dive | Ocean Diver
OD06 |  | Large Boat Dive | Ocean Diver
OD07 |  | Wall Dive | Ocean Diver
OD08 |  | Dive In Protective Clothing | Ocean Diver
OD09 |  | Maximum Depth Achieved In Training | Ocean Diver
OD10 |  | Minimum Of Four/Five Dives 120 Minutes Confirmed | Ocean Diver
OD11 |  | Depth Progression To 20m | Ocean Diver
ODTA | Assessment | Theory Assessment | Ocean Diver
OO1 | Open Water Lesson | The First Open Water Dive | Ocean Diver
OO2 | Open Water Lesson | The Second Open Water Dive | Ocean Diver
OO3 | Open Water Lesson | The Third Open Water Dive | Ocean Diver
OO4 | Open Water Lesson | The Fourth Open Water Dive | Ocean Diver
OO5 | Open Water Lesson | The Fifth Open Water Dive | Ocean Diver
OS1 | Sheltered Water Lesson | Being Underwater | Ocean Diver
OS2 | Sheltered Water Lesson | Basic Sills | Ocean Diver
OS3 | Sheltered Water Lesson | [NAME] | Ocean Diver
OS4 | Sheltered Water Lesson | Beyond [NAME] | Ocean Diver
OS5 | Sheltered Water Lesson | Safety Skills | Ocean Diver
OT1 | [NAME] | Ocean Diver Training | Ocean Diver
OT2 | [NAME] | Diving Equipment And Diving Signals | Ocean Diver
OT3 | [NAME] | The Body And Effects Of Diving | Ocean Diver
OT4 | [NAME] | Planning To Go Diving | Ocean Diver
OT5 | [NAME] | Going Diving | Ocean Diver
OT6 | [NAME] | What [NAME] If? | Ocean Diver
OT7 | [NAME] | Enjoying Your Diving | Ocean Diver
SC1 | Self Certification Of Fitness To Dive Confirmed |  | Ocean Diver
SDE1 |  | Shelving Shore Dive | Sports Diver
SDE10 |  | Minimum Of Dive Dives/150 Minutes Confirmed [NAME] As Ocean Diver | Sports Diver
SDE2 |  | Steep Shore Dive | Sports Diver
SDE3 |  | Dive Using A Short Line | Sports Diver
SDE4 |  | Low [NAME] | Sports Diver
SDE5 |  | Drift Dive | Sports Diver
SDE6 |  | Small Boat Dive | Sports Diver
SDE7 |  | Large Boat Dive | Sports Diver
SDE8 |  | Wall Dive | Sports Diver
SDE9 |  | Dive In Protection Clothing | Sports Diver
SDPQE1 | Depth Progression | 25m | Sports Diver
SDPQE2 | Depth Progression | 30m | Sports Diver
SDPQE3 | Depth Progression | 35m | Sports Diver
SDTA |  | Theory Assessment | Sports Diver
SO1 | Open Water Lesson | Dive Rescue | Sports Diver
SO2 | Opening Water Lesson | Use Of SMB | Sports Diver
SO3 | Open Water Lesson | Simulated Decompression Dive | Sports Diver
SO4 | Open Water Lesson | Compass Navigation/Dsmb Deployment | Sports Diver
SO5 | Open Water Lesson | Diving Leading/Basic Sills Review | Sports Diver
SP1 | Dry Practical Lesson | Assistant Dive Marshal | Sports Diver
SS1 | Sheltered Water Lesson | Rescue Skills | Sports Diver
ST1 | [NAME] | Sports Diving | Sports Diver
ST2 | [NAME] | Diver Rescue | Sports Diver
ST3 | [NAME] | Equipment And Techniques | Sports Diver
ST4 | [NAME] | [NAME] | Sports Diver
ST5 | [NAME] | Air Planning And Systems | Sports Diver
ST6 | [NAME] | Going Diving | Sports Diver