Spreadsheet: 735895d1623250840-hi-i-would-like-to-use-2-or-3-isnumber-search-functions-in-1-formula-test-isnumber-1-formula
Sheet: Sheet1

Volgnummer | Periode | Weeknr | Tdatum | Opleiding | [NAME] | Omschrijving | Van | Tot | Lokatie | E_Lokatie | Soort | Aantal deelnemers | Verdeling
2765 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 38 | Test
2997 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 324 | Test
2888 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 26 | Test
2780 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 4 | Test
3166 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 09:00:00 | 10:30:00 | ZP07/A1.110 | U103, U101 | Test | 50 | Test
3167 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 11:00:00 | 12:30:00 | ZP07/A1.110 | U103, U101 | Test | 50 | Test
2793 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/C201 |  | Test | 7 | Test
2833 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | 195 | Test
4050 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | 130 | Test
2916 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | 230 | Test
3255 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 3 | Test
3285 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 24 | Test
3233 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 34 | Test
1052995 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 20:45:00 | Thuis |  | Test | 30 | Test
3241 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 39 | Test
3252 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 4 | Test
3282 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis |  | Test | 20 | Test
3245 | Test | 23 | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis |  | Test | 30 | Test
2867 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 328 | Test
3384 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:00:00 | Energy Barn |  | Test | 26 | Test
3085 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis |  | Test | 50 | Test
2155 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Energy Barn |  | Test | 174 | Test
2938 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | 152 | Test
3417 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:00:00 | Stadskerk |  | Test | 104 | Test
4194 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | 17 | Test
2800 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | 9 | Test
2816 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | 15 | Test
3127 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 13:00:00 | 21:15:00 | ZP07/F202 | ZP23/B202, C201, ZP11: A120, B138, A133, B120, ZP09: D112, D219 | Test | 198 | Test
3312 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 14:30:00 | 16:00:00 | ZP07/A0.100 | Energy Barn, ZP07/A0.077, A0.069, A0.031 | Test | 170 | Test
2974 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Hanzeplaza |  | Test | 150 | Test
1052993 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 17:00:00 | 18:30:00 | Thuis |  | Test | 30 | Test
3271 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 22 | Test
3741 | Test | 23 | 2021-06-08 00:00:00 | Test | Test | Test | 19:00:00 | 20:30:00 | Energy Barn |  | Test | 19 | Test
3179 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 08:30:00 | 11:00:00 | Thuis OS |  | Test | 42 | Test
3092 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis |  | Test | 320 | Test
2911 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | 293 | Test
1929 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Energy Barn | ZP07/A1.110 | Test | 90 | Test
2122 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:00:00 | Thuis OS |  | Test | 220 | Test
2757 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | 89 | Test
2840 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | 172 | Test
2023 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 18:00:00 | Thuis |  | Test | 75 | Test
2007 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 18:00:00 | Thuis |  | Test | 200 | Test
2769 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | 37 | Test
2892 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | 35 | Test
3222 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | 31 | Test
3226 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | 78 | Test
3254 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 24 | Test
3292 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 31 | Test
3257 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 2 | Test
3236 | Test | 23 | 2021-06-09 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 20 | Test
1931 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | ZP07/A1.110 |  | Test | 40 | Test
2092 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 11:00:00 | ZP09/D232 | ZP09/D126, ZP07/A2.111 | Test | 101 | Test
3651 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 213 | Test
3643 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 45 | Test
3635 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 151 | Test
2999 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 290 | Test
1052925 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 11:30:00 | Thuis OS |  | Test | 23 | Test
1052918 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 09:30:00 | 11:30:00 | Thuis OS |  | Test | 25 | Test
4320 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | 24 | Test
2962 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | 167 | Test
2852 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | 68 | Test
2932 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | 63 | Test
3209 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | 13 | Test
3270 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 12 | Test
3273 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 22 | Test
3250 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 5 | Test
3301 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | 65 | Test
3739 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 18:30:00 | 20:30:00 | Energy Barn |  | Test | 28 | Test
3290 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 18 | Test
3264 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 15 | Test
3296 | Test | 23 | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | 74 | Test
1932 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Energy Barn |  | Test | 50 | Test
2878 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 11:30:00 | Thuis OS |  | Test | 118 | Test
3090 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | 207 | Test
3168 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 09:00:00 | 10:30:00 | ZP07/A1.110 | ZP07/U103, U101 | Test | 50 | Test
4230 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 10:30:00 | 13:30:00 | ZP11/A120 |  | Test | 10 | Test
3169 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 11:00:00 | 12:30:00 | ZP07/A1.110 | ZP07/U103, U101 | Test | 50 | Test
2975 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Hanzeplaza |  | Test | 97 | Test
2905 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | 311 | Test
2371 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | 64 | Test
2374 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | 36 | Test
2380 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | 201 | Test
2377 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | 46 | Test
4280 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | ZP09/D232 | ZP07/A1.110 | Test | 74 | Test
3326 | Test | 23 | 2021-06-11 00:00:00 | Test | Test | Test | 17:00:00 | 18:30:00 | ZP09/D232 | ZP07/A1.110, ZP11/B138, ZP11/A133, ZP11/A120, ZP11/B120 | Test | 139 | Test