Spreadsheet: 94839d1294607432-retreiving-multiple-matches-values-in-same-row-if-x-is-true-1test
Sheet: DATA

 |  | Input Date | 2011-01-01 00:00:00 |  |  |  | Input Date | 2011-01-02 00:00:00 |  |  |  | Input Date | 2011-01-03 00:00:00 |  |  |  | Input Date | 2011-01-04 00:00:00 |  |  |  | Input Date | 2011-01-05 00:00:00
Employee Name | [NAME]. | Production | Hours | Line | Zone | [NAME]. | Production | Hours | Line | Zone | [NAME]. | Production | Hours | Line | Zone | [NAME]. | Production | Hours | Line | Zone | [NAME]. | Production | Hours | Line | Zone
[NAME] | 350 | 2800 | 8 | Line A | Zone 1 |  |  |  |  |  | 384 | 3072 | 8 | Line A | Zone 1 | 332 | 2656 | 8 | Line A | Zone 1 | 326 | 2608 | 8 | Line A | Zone 1
[NAME] | 400 | 3200 | 8 | Line A | Zone 2 | 406 | 3045 | 7.5 | Line A | Zone 2 | 434 | 3472 | 8 | Line A | Zone 2 | 382 | 3056 | 8 | Line A | Zone 2 | 376 | 3008 | 8 | Line A | Zone 2
[NAME] | 500 | 4000 | 8 | Line A | Zone 3 | 506 | 3795 | 7.5 | Line A | Zone 3 |  |  |  |  |  | 482 | 3856 | 8 | Line A | Zone 3 | 476 | 3808 | 8 | Line A | Zone 3
[NAME] | 300 | 2400 | 8 | Line A | Zone 4 | 306 | 2295 | 7.5 | Line A | Zone 4 | 334 | 2672 | 8 | Line A | Zone 4 | 282 | 2256 | 8 | Line A | Zone 4 | 276 | 2208 | 8 | Line A | Zone 4
[NAME] | 450 | 3600 | 8 | Line A | Zone 5 | 456 | 3420 | 7.5 | Line A | Zone 5 | 534 | 4272 | 8 | Line A | Zone 3 | 432 | 3456 | 8 | Line A | Zone 5 | 426 | 3408 | 8 | Line A | Zone 5
[NAME] | 342 | 2736 | 7.75 | Line B | Zone 1 | 349 | 2792 | 8 | Line B | Zone 1 | 376 | 3008 | 8 | Line B | Zone 1 | 325 | 2600 | 8 | Line B | Zone 1 | 318 | 2544 | 8 | Line B | Zone 1
[NAME] |  |  |  |  |  | 409 | 3272 | 8 | Line B | Zone 2 | 436 | 3488 | 8 | Line B | Zone 2 | 385 | 3080 | 8 | Line B | Zone 2 | 378 | 3024 | 8 | Line B | Zone 2
[NAME] | 502 | 4016 | 7.75 | Line B | Zone 3 | 509 | 4072 | 8 | Line B | Zone 3 | 536 | 4288 | 8 | Line B | Zone 3 | 485 | 3880 | 8 | Line B | Zone 3 | 478 | 3824 | 8 | Line B | Zone 3
[NAME] | 305 | 2440 | 7.75 | Line B | Zone 4 | 312 | 2496 | 8 | Line B | Zone 4 | 339 | 2712 | 8 | Line B | Zone 4 | 288 | 2304 | 8 | Line B | Zone 4 | 281 | 2248 | 8 | Line B | Zone 4
[NAME] | 456 | 3648 | 7.75 | Line B | Zone 5 | 463 | 3704 | 8 | Line B | Zone 5 | 490 | 3920 | 8 | Line B | Zone 5 | 439 | 3512 | 8 | Line B | Zone 5 | 432 | 3456 | 8 | Line B | Zone 5
[NAME] | 344 | 2752 | 8 | Line C | Zone 1 | 364 | 2730 | 7.5 | Line C | Zone 1 | 378 | 3024 | 8 | Line C | Zone 1 | 340 | 2720 | 8 | Line C | Zone 1 | 320 | 2560 | 8 | Line C | Zone 1
[NAME] Bright | 386 | 3088 | 8 | Line C | Zone 2 | 406 | 3045 | 7.5 | Line C | Zone 2 | 420 | 3360 | 8 | Line C | Zone 2 | 382 | 3056 | 8 | Line C | Zone 2 | 362 | 2896 | 8 | Line C | Zone 2
[NAME] | 485 | 3880 | 8 | Line C | Zone 3 | 505 | 3787.5 | 7.5 | Line C | Zone 3 | 519 | 4152 | 8 | Line C | Zone 3 | 481 | 3848 | 8 | Line C | Zone 3 | 461 | 3688 | 8 | Line C | Zone 3
[NAME] | 275 | 2200 | 8 | Line C | Zone 4 | 295 | 2212.5 | 7.5 | Line C | Zone 4 | 309 | 2472 | 8 | Line C | Zone 4 | 271 | 2168 | 8 | Line C | Zone 4 | 251 | 2008 | 8 | Line C | Zone 4
[NAME] | 422 | 3376 | 8 | Line C | Zone 5 | 442 | 3315 | 7.5 | Line C | Zone 5 | 456 | 3648 | 8 | Line C | Zone 5 | 418 | 3344 | 8 | Line C | Zone 5 | 398 | 3184 | 8 | Line C | Zone 5
[NAME] | 327 | 2616 | 7.5 | Line D | Zone 1 | 380 | 3040 | 8 | Line D | Zone 1 | 361 | 2888 | 8 | Line D | Zone 1 | 356 | 2848 | 8 | Line D | Zone 1 | 325 | 2600 | 8 | Line D | Zone 1
[NAME] | 376 | 3008 | 7.5 | Line D | Zone 2 | 429 | 3432 | 8 | Line D | Zone 2 | 410 | 3280 | 8 | Line D | Zone 2 | 405 | 3240 | 8 | Line D | Zone 2 | 385 | 3080 | 8 | Line D | Zone 2
[NAME] | 497 | 3976 | 7.5 | Line D | Zone 3 | 550 | 4400 | 8 | Line D | Zone 3 | 531 | 4248 | 8 | Line D | Zone 3 | 526 | 4208 | 8 | Line D | Zone 3 | 485 | 3880 | 8 | Line D | Zone 3
[NAME] | 284 | 2272 | 7.5 | Line D | Zone 4 | 337 | 2696 | 8 | Line D | Zone 4 | 318 | 2544 | 8 | Line D | Zone 4 | 313 | 2504 | 8 | Line D | Zone 4 | 288 | 2304 | 8 | Line D | Zone 4
Clarissa Roberson | 442 | 3536 | 7.5 | Line D | Zone 5 | 495 | 3960 | 8 | Line D | Zone 5 | 476 | 3808 | 8 | Line D | Zone 5 | 471 | 3768 | 8 | Line D | Zone 5 | 439 | 3512 | 8 | Line D | Zone 5
[NAME] | 402 | 3216 | 7.75 | Line B | Zone 2 | 356 | 2670 | 7.5 | Line A | Zone 1 | 484 | 3872 | 8 | Line A | Zone 5
 |  |  | Zone 1=
 |  |  | Zone 2=
 |  |  | Zone 3=
 |  |  | Zone 4=
 |  |  | Zone 5=
 | Total |  |  | Zone 1 Totals |  |  | Zone 2 Totals |  |  | Zone 3 Totals |  |  | Zone 4 Totals |  |  | Zone 5 Totals
Employee Name | [NAME]. | Production | Hours | [NAME]. | Production | Hours | [NAME]. | Production | Hours | [NAME]. | Production | Hours | [NAME]. | Production | Hours | [NAME]. | Production | Hours
[NAME] | 348 | 11136 | 32 | 348 | 11136 | 32
[NAME] | 398 | 15781 | 39.5 |  |  |  | 398 | 15781 | 39.5
[NAME] | 486 | 15459 | 31.5 |  |  |  |  |  |  | 486 | 15459 | 31.5
[NAME] | 298 | 11831 | 39.5 |  |  |  |  |  |  |  |  |  | 298 | 11831 | 39.5
[NAME] | 497.25 | 18156 | 39.5 |  |  |  |  |  |  | 534 | 4272 | 8 |  |  |  | 460.5 | 13884 | 31.5
[NAME] | 340.25 | 13680 | 39.75 | 340.25 | 13680 | 39.75
[NAME] | 399.7 | 12864 | 32 |  |  |  | 399.7 | 12864 | 32
[NAME] | 500.3 | 20080 | 39.75 |  |  |  |  |  |  | 500.3 | 20080 | 39.75
[NAME] | 303.3 | 12200 | 39.75 |  |  |  |  |  |  |  |  |  | 303.3 | 12200 | 39.75
[NAME] | 454.3 | 18240 | 39.75 |  |  |  |  |  |  |  |  |  |  |  |  | 454.3 | 18240 | 39.75
[NAME] | 345.5 | 13786 | 39.5 | 345.5 | 13786 | 39.5
[NAME] Bright | 387.5 | 15445 | 39.5 |  |  |  | 387.5 | 15445 | 39.5
[NAME] | 486.5 | 19355.5 | 39.5 |  |  |  |  |  |  | 486.5 | 19355.5 | 39.5
[NAME] | 276.5 | 11060.5 | 39.5 |  |  |  |  |  |  |  |  |  | 276.5 | 11060.5 | 39.5
[NAME] | 423.5 | 16867 | 39.5 |  |  |  |  |  |  |  |  |  |  |  |  | 423.5 | 16867 | 39.5
[NAME] | 342.25 | 13992 | 39.5 | 342.25 | 13992 | 39.5
[NAME] | 394 | 16040 | 39.5 |  |  |  | 394 | 16040 | 39.5
[NAME] | 509.8 | 20712 | 39.5 |  |  |  |  |  |  | 509.8 | 20712 | 39.5
[NAME] | 300.8 | 12320 | 39.5 |  |  |  |  |  |  |  |  |  | 300.8 | 12320 | 39.5
Clarissa Roberson | 457 | 18584 | 39.5 |  |  |  |  |  |  |  |  |  |  |  |  | 457 | 18584 | 39.5
[NAME] | 414 | 9758 | 23.25 | 356 | 2670 | 7.5 | 402 | 3216 | 7.75 |  |  |  |  |  |  | 484 | 3872 | 8