Spreadsheet: 744706d1629386311-way-to-pull-current-items-display-multiple-values-which-meet-criteria-chloeyal-
Sheet: Sheet4

Person | Item | Start Date | End Date
person 1 | Name 1 | 2008-05-08 00:00:00 | 2018-07-25 00:00:00
person 1 | Name 2 | 2008-05-08 00:00:00 | 2016-08-19 00:00:00
person 1 | Name 3 | 2008-05-08 00:00:00 | 2009-05-15 00:00:00
person 1 | Name 4 | 2018-07-25 00:00:00
person 1 | Name 5 | 2019-09-01 00:00:00
person 1
person 1
person 1
person 1
person 1
person 2 | Name 2 | 2000-01-02 00:00:00 | 2001-01-02 00:00:00
person 2 | Name 3 | 2002-01-02 00:00:00 | 2003-01-02 00:00:00
person 2 | Name 4 | 2002-01-02 00:00:00 | 2005-01-02 00:00:00
person 2 | Name 5 | 2006-01-02 00:00:00 | 2007-01-02 00:00:00
person 2 | Name 6 | 2008-01-02 00:00:00 | 2009-01-02 00:00:00
person 2 | Name 7 | 2010-01-02 00:00:00 | 2011-01-02 00:00:00
person 2 | Name 8 | 2012-01-02 00:00:00 | 2013-01-02 00:00:00
person 2 | Name 9 | 2014-01-02 00:00:00 | 2015-01-02 00:00:00
person 2 | Name 10 | 2016-01-02 00:00:00 | 2017-01-02 00:00:00
person 2 | Name 2 | 2018-01-02 00:00:00 | 2019-01-02 00:00:00
person 3 | Name 3 | 2000-01-03 00:00:00 | 2001-01-03 00:00:00
person 3 | Name 4 | 2002-01-03 00:00:00 | 2003-01-03 00:00:00
person 3 | Name 5 | 2004-01-03 00:00:00 | 2005-01-03 00:00:00
person 3 | Name 6 | 2006-01-03 00:00:00 | 2007-01-03 00:00:00
person 3 | Name 7 | 2008-01-03 00:00:00 | 2009-01-03 00:00:00
person 3 | Name 8 | 2010-01-03 00:00:00 | 2011-01-03 00:00:00
person 3 | Name 9 | 2012-01-03 00:00:00
person 3
person 3
person 3
person 4 | Name 4 | 2000-01-04 00:00:00 | 2001-01-04 00:00:00
person 4 | Name 5 | 2002-01-04 00:00:00 | 2003-01-04 00:00:00
person 4 | Name 6 | 2004-01-04 00:00:00 | 2005-01-04 00:00:00
person 4 | Name 7 | 2006-01-04 00:00:00 | 2007-01-04 00:00:00
person 4 | Name 8 | 2008-01-04 00:00:00 | 2009-01-04 00:00:00
person 4 | Name 9 | 2010-01-04 00:00:00 | 2011-01-04 00:00:00
person 4 | Name 10 | 2012-01-04 00:00:00 | 2013-01-04 00:00:00
person 4 | Name 4 | 2014-01-04 00:00:00 | 2015-01-04 00:00:00
person 4 | Name 4 | 2016-01-04 00:00:00 | 2017-01-04 00:00:00
person 4 | Name 4 | 2018-01-04 00:00:00 | 2019-01-04 00:00:00
person 5 | Name 5 | 2000-01-05 00:00:00 | 2001-01-05 00:00:00
person 5 | Name 6 | 2002-01-05 00:00:00 | 2003-01-05 00:00:00
person 5 | Name 7 | 2004-01-05 00:00:00 | 2005-01-05 00:00:00
person 5 | Name 8 | 2006-01-05 00:00:00 | 2007-01-05 00:00:00
person 5 | Name 9 | 2008-01-05 00:00:00
person 5 | Name 10 | 2010-01-05 00:00:00
person 5 | Name 8 | 2012-01-05 00:00:00
person 5
person 5
person 5
person 6 | Name 6 | 2000-01-06 00:00:00 | 2001-01-06 00:00:00
person 6 | Name 7 | 2002-01-06 00:00:00 | 2003-01-06 00:00:00
person 6 | Name 8 | 2004-01-06 00:00:00 | 2005-01-06 00:00:00
person 6 | Name 9 | 2006-01-06 00:00:00 | 2007-01-06 00:00:00
person 6 | Name 10 | 2008-01-06 00:00:00 | 2009-01-06 00:00:00
person 6 | Name 6 | 2010-01-06 00:00:00 | 2011-01-06 00:00:00
person 6 | Name 6 | 2012-01-06 00:00:00 | 2013-01-06 00:00:00
person 6 | Name 6 | 2014-01-06 00:00:00 | 2015-01-06 00:00:00
person 6 | Name 6 | 2016-01-06 00:00:00 | 2017-01-06 00:00:00
person 6 | Name 6 | 2018-01-06 00:00:00 | 2019-01-06 00:00:00
person 7 | Name 7 | 2000-01-07 00:00:00 | 2001-01-07 00:00:00
person 7 | Name 8 | 2002-01-07 00:00:00 | 2003-01-07 00:00:00
person 7 | Name 9 | 2004-01-07 00:00:00 | 2005-01-07 00:00:00
person 7 | Name 10 | 2006-01-07 00:00:00 | 2007-01-07 00:00:00
person 7 | Name 7 | 2008-01-07 00:00:00
person 7 | Name 7 | 2010-01-07 00:00:00 | 2011-01-07 00:00:00
person 7 | Name 7 | 2012-01-07 00:00:00 | 2013-01-07 00:00:00
person 7 | Name 7 | 2014-01-07 00:00:00 | 2015-01-07 00:00:00
person 7 | Name 7 | 2016-01-07 00:00:00 | 2017-01-07 00:00:00
person 7 | Name 7 | 2018-01-07 00:00:00 | 2019-01-07 00:00:00
person 8 | Name 8 | 2000-01-08 00:00:00 | 2001-01-08 00:00:00
person 8 | Name 9 | 2002-01-08 00:00:00 | 2003-01-08 00:00:00
person 8 | Name 10 | 2004-01-08 00:00:00 | 2005-01-08 00:00:00
person 8 | Name 8 | 2006-01-08 00:00:00 | 2007-01-08 00:00:00
person 8 | Name 8 | 2008-01-08 00:00:00 | 2009-01-08 00:00:00
person 8 | Name 8 | 2010-01-08 00:00:00 | 2011-01-08 00:00:00
person 8 | Name 3 | 2012-01-08 00:00:00 | 2013-01-08 00:00:00
person 8 | Name 8 | 2014-01-08 00:00:00 | 2015-01-08 00:00:00
person 8 | Name 2 | 2016-01-08 00:00:00 | 2017-01-08 00:00:00
person 8
person 9 | Name 9 | 2000-01-09 00:00:00 | 2001-01-09 00:00:00
person 9 | Name 10 | 2002-01-09 00:00:00 | 2003-01-09 00:00:00
person 9 | Name 9 | 2004-01-09 00:00:00 | 2005-01-09 00:00:00
person 9 | Name 9 | 2006-01-09 00:00:00 | 2007-01-09 00:00:00
person 9 | Name 9 | 2008-01-09 00:00:00 | 2009-01-09 00:00:00
person 9 | Name 9 | 2010-01-09 00:00:00 | 2011-01-09 00:00:00
person 9 | Name 9 | 2012-01-09 00:00:00 | 2013-01-09 00:00:00
person 9 | Name 9 | 2014-01-09 00:00:00 | 2015-01-09 00:00:00
person 9 | Name 2 | 2016-01-09 00:00:00 | 2017-01-09 00:00:00
person 9
person 10 | Name 10 | 2000-01-10 00:00:00 | 2001-01-10 00:00:00
person 10 | Name 10 | 2002-01-10 00:00:00 | 2003-01-10 00:00:00
person 10 | Name 10 | 2004-01-10 00:00:00 | 2005-01-10 00:00:00
person 10 | Name 10 | 2006-01-10 00:00:00 | 2007-01-10 00:00:00
person 10 | Name 10 | 2008-01-10 00:00:00 | 2009-01-10 00:00:00
person 10 | Name 10 | 2010-01-10 00:00:00 | 2011-01-10 00:00:00
person 10 | Name 10 | 2012-01-10 00:00:00 | 2013-01-10 00:00:00
person 10 | Name 10 | 2014-01-10 00:00:00 | 2015-01-10 00:00:00
person 10 | Name 1 | 2016-01-10 00:00:00
person 10
 |  |  | Person |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Current
 |  |  | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 1
 |  |  | Person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 2
 |  |  | Person 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 3
 |  |  | Person 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 4
 |  |  | Person 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 5
 |  |  | Person 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 6
 |  |  | Person 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 7
 |  |  | Person 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 8
 |  |  | Person 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 9
 |  |  | Person 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person 10