Spreadsheet: 724825d1616406687-check-for-date-in-range-with-multiple-criteria-test-cross-check
Sheet: Source

ID Code | DateTime | Code 01 | Units 01 | Code 02 | Units 02 | Code 03 | Units 03 | Code 04 | Units 04 | Code 05 | Units 05 | Code 06 | Units 06 | Code 07 | Units 07 | Code 08 | Units 08 | Code 09 | Units 09 | Code 10 | Units 10 | SPACE | Date | Expected result |  |  | Codes to check:
469 | 20210101083000 | &PHNW | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | &ANN
469 | 20210104083000 | OPD | 4 |  | 0 |  | 0 |  | 0 |  | 0 | &PER | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | O |  |  | &PER
469 | 20210105083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A |  |  | &CAR
469 | 20210106083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A |  |  | &OPD
469 | 20210107083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A |  |  | &LSL
469 | 20210108083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A |  |  | &DOM
469 | 20210111083000 |  | 0 |  | 0 | &ORD | 3.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | &STUD
469 | 20210125083000 |  | 0 |  | 0 | &ORD | 3.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210125130000 |  | 0 |  | 0 | &ORD | 4.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210126083000 | &PHNW | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210127083000 |  | 0 |  | 0 | &ORD | 3.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210205133500 |  | 0 |  | 0 | &ORD | 0.67 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210208093000 | &PER | 5 | &OTA | 0.07 | &ORD | 3.68 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | S
469 | 20210208141500 |  | 0 | &OTA | 0.1 | &ORD | 4.82 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | &PER | 6 |  | 0 |  |  | S
469 | 20210209093000 |  | 0 |  | 0 | &ORD | 3.67 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210212094000 |  | 0 |  | 0 | &ORD | 3.75 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
469 | 20210212143500 |  | 0 |  | 0 | &ORD | 2.13 | &PTA | 1.37 |  | 0 |  | 0 | &PER | 5 |  | 0 |  | 0 |  | 0 |  |  | MISSING
469 | 20210215083000 |  | 0 |  | 0 | &ORD | 3.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210120133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210121090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210121133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210122090000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210127090000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210128090000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210129090000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | MISSING
2708 | 20210203083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210204083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210205083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210210083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210211083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210212083000 | &ANN | 7.6 |  | 0 | &AL17 | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | A
2708 | 20210217090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210217133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210218090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210218133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210219090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 | &CAR | 2 |  | 0 |  | 0 |  | 0 |  |  | R
2708 | 20210219133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210224090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210224133000 |  | 0 |  | 0 | &ORD | 3.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2708 | 20210225090000 |  | 0 |  | 0 | &ORD | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0