Spreadsheet: 860630d1708649611-stuck-on-complicated-data-validation-drop-down-list-booking-slot-test-3-beamer
Sheet: Sheet 1

 | 2 | 07:45 - 09:00
 | 3 | 10:15 - 11:00
 | 3 | 13:15 - 16:00
 |  |  |  |  |  | Date | Yard | Available Slots |  |  |  |  | Date | Unique No. | Yard | Times | Available Slots | Date | Unique No. | Yard | Times | Available Slots | Date | Unique No. | Yard | Times | Available Slots |  | date | yard | slot
 |  |  |  |  |  | 2024-02-20 00:00:00 | 2 |  |  |  |  |  | 2024-02-20 00:00:00 | 1 | 2 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 |  |  |  |  |  | 2024-02-20 00:00:00 | 3 |  |  |  |  |  | 2024-02-20 00:00:00 | 2 | 2 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 |  | Yard | Time Slot |  |  | 2024-02-20 00:00:00 | 4 |  |  |  |  |  | 2024-02-20 00:00:00 | 3 | 2 | 13:15 - 16:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 | 07:45 - 09:00 |  |  | 2024-02-20 00:00:00 | 5 |  |  |  |  |  | 2024-02-20 00:00:00 | 4 | 3 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 | 10:15 - 11:00 |  |  |  | 2 |  |  |  |  |  | 2024-02-20 00:00:00 | 5 | 3 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 | 13:15 - 16:00 |  |  |  | 3 |  |  |  |  |  | 2024-02-20 00:00:00 | 6 | 3 | 13:15 - 16:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 |  |  |  |  | 4 |  |  |  |  |  | 2024-02-20 00:00:00 | 7 | 4 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 |  |  |  |  | 5 |  |  |  |  |  | 2024-02-20 00:00:00 | 8 | 4 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 2
 | 2024-02-20 00:00:00 | 2 |  |  |  |  | 2 |  |  |  |  |  | 2024-02-20 00:00:00 | 9 | 4 | 13:15 - 16:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 2 |  |  |  |  | 3 |  |  |  |  |  | 2024-02-20 00:00:00 | 10 | 5 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 2 |  |  |  |  | 4 |  |  |  |  |  | 2024-02-20 00:00:00 | 11 | 5 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 | 10:15 - 11:00 |  |  |  | 5 |  |  |  |  |  | 2024-02-20 00:00:00 | 12 | 5 | 13:15 - 16:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 | 13:15 - 16:00 |  |  |  | 2 |  |  |  |  |  |  | 13 | 2 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 |  |  |  |  | 3 |  |  |  |  |  |  | 14 | 2 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 |  |  |  |  | 4 |  |  |  |  |  |  | 15 | 2 | 13:15 - 16:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 |  |  |  |  | 5 |  |  |  |  |  |  | 16 | 3 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 3
 | 2024-02-20 00:00:00 | 3 | 07:45 - 09:00 |  |  |  | 2 |  |  |  |  |  |  | 17 | 3 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 3 |  |  |  |  | 3 |  |  |  |  |  |  | 18 | 3 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 3 |  |  |  |  | 4 |  |  |  |  |  |  | 19 | 4 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  | 5 |  |  |  |  |  |  | 20 | 4 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 21 | 4 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 22 | 5 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 4 | 07:45 - 09:00 |  |  |  |  |  |  |  |  |  |  | 24 | 5 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 25 | 2 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 26 | 2 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 27 | 2 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 5 | 10:15 - 11:00 |  |  |  |  |  |  |  |  |  |  | 28 | 3 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 29 | 3 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 30 | 3 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 31 | 4 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 32 | 4 | 10:15 - 11:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 33 | 4 | 13:15 - 16:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 34 | 5 | 07:45 - 09:00
 | 2024-02-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 35 | 5 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 5 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 2 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 2 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 2 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 3 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 3 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 3 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 4 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 4 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 4 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 5 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | 5 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 5 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 2 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 2 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 2 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 3 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 3 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 | 3 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | 4 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 4 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 4 | 13:15 - 16:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 5 | 07:45 - 09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | 5 | 10:15 - 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 5 | 13:15 - 16:00