Spreadsheet: 732232d1620831094-returning-unique-value-with-multiple-criteria-returning-unique-value-with-multiple-criteria-v2
Sheet: TIMECARD DATA

CREW | PERSON | DATE
ABC | SUSAN | 2017-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | ABC | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | DOUG | 2017-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | ABC | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | PETER | 2017-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | ABC | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | SUSAN | 2017-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | STEVE | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | SUSAN | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | DOUG | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | [NAME] | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | [NAME] | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | SUSAN | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | STEVE | 2017-11-03 00:00:00 |  |  |  |  |  |  |  |  |  | GHI | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | SUSAN | 2018-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | GHI | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | DOUG | 2018-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | GHI | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | [NAME] | 2018-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | JKL | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | SUSAN | 2018-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | JKL | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | JKL | JKL
ABC | DOUG | 2018-05-12 00:00:00
ABC | DOUG | 2018-05-12 00:00:00
ABC | PETER | 2018-05-12 00:00:00
ABC | SUSAN | 2018-05-12 00:00:00
ABC | SUSAN | 2019-01-08 00:00:00
ABC | [NAME] | 2019-05-19 00:00:00
ABC | [NAME] | 2019-05-19 00:00:00
ABC | [NAME] | 2019-08-03 00:00:00
ABC | [NAME] | 2019-08-03 00:00:00
ABC | DOUG | 2019-12-01 00:00:00
ABC | DOUG | 2019-12-01 00:00:00
ABC | [NAME] | 2019-12-01 00:00:00
ABC | SUSAN | 2019-12-01 00:00:00
ABC | DOUG | 2020-02-03 00:00:00
ABC | SUSAN | 2020-02-03 00:00:00
ABC | SUSAN | 2020-03-15 00:00:00
ABC | DOUG | 2020-07-18 00:00:00
DEF | [NAME] | 2017-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | JOE | 2017-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | [NAME] | 2017-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | JOE | 2017-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | DOUG | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | DOUG | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | [NAME] | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
DEF | [NAME] | 2017-11-03 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
DEF | [NAME] | 2017-11-03 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
DEF | [NAME] | 2017-11-03 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
DEF | [NAME] | 2018-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | JKL
DEF | [NAME] | 2018-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | JKL
DEF | [NAME] | 2018-02-06 00:00:00
DEF | [NAME] | 2018-03-05 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | STEVE | 2018-05-12 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | STEVE | 2019-01-08 00:00:00
DEF | [NAME] | 2019-05-19 00:00:00
DEF | DOUG | 2019-08-03 00:00:00
DEF | [NAME] | 2019-08-03 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | STEVE | 2019-12-01 00:00:00
DEF | STEVE | 2019-12-01 00:00:00
DEF | JOE | 2019-12-01 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | DOUG | 2020-02-03 00:00:00
DEF | [NAME] | 2020-02-03 00:00:00
DEF | STEVE | 2020-02-03 00:00:00
DEF | JOE | 2020-02-03 00:00:00
DEF | STEVE | 2020-03-15 00:00:00
DEF | [NAME] | 2020-03-15 00:00:00
DEF | JOE | 2020-07-18 00:00:00
GHI | PETER | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
GHI | JOE | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
GHI | [NAME] | 2017-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
GHI | PETER | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
GHI | JOE | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
GHI | PETER | 2018-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
GHI | JOE | 2018-05-12 00:00:00 |  |  |  |  |  |  |  |  |  | GHI
GHI | [NAME] | 2019-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | JKL
GHI | JOE | 2019-05-19 00:00:00 |  |  |  |  |  |  |  |  |  | JKL
GHI | [NAME] | 2019-05-19 00:00:00
GHI | [NAME] | 2020-02-03 00:00:00
GHI | [NAME] | 2020-03-15 00:00:00
GHI | [NAME] | 2020-07-18 00:00:00
JKL | SUSAN | 2017-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | ABC
JKL | SUSAN | 2018-05-12 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
JKL | SUSAN | 2018-05-12 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
JKL | [NAME] | 2019-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
JKL | [NAME] | 2019-08-03 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
JKL | [NAME] | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | DEF
JKL | [NAME] | 2020-02-03 00:00:00
JKL | SUSAN | 2020-07-18 00:00:00