Spreadsheet: 740143d1626197228-way-to-pull-current-items-display-multiple-values-which-meet-criteria-chloeyal-
Sheet: Sheet1

 | Item 1 | Start Date 1 | End Date 1 | Item 2 | Start Date 2 | End Date 2 | Item 3 | Start Date 3 | End Date 3 | Item 4 | Start Date 4 | End Date 4 | Item 5 | Start Date 5 | End Date 5 | Item 6 | Start Date 6 | End Date 6 | Item 7 | Start Date 7 | End Date 7 | Item 8 | Start Date 8 | End Date 8 | Item 9 | Start Date 9 | End Date 9 | Item 10 | Start Date 10 | End Date 10 | [NAME] | [NAME] | [NAME] | [NAME] |  | First Set of Items |  |  |  |  |  | Second Set of Items |  |  |  |  |  |  | Third Set of Items |  |  |  |  |  |  | Current Items |  |  |  |  |  |  |  |  |  | Current Names
person 1 | Name 1 | 2008-05-08 00:00:00 | 2018-07-25 00:00:00 | Name 2 | 2008-05-08 00:00:00 | 2016-08-19 00:00:00 | Name 3 | 2008-05-08 00:00:00 | 2009-05-15 00:00:00 | Name 4 | 2018-07-25 00:00:00 |  | Name 5 | 2019-09-01 00:00:00
person 2 | Name 2 | 2000-01-02 00:00:00 | 2001-01-02 00:00:00 | Name 3 | 2002-01-02 00:00:00 | 2003-01-02 00:00:00 | Name 4 | 2002-01-02 00:00:00 | 2005-01-02 00:00:00 | Name 5 | 2006-01-02 00:00:00 | 2007-01-02 00:00:00 | Name 6 | 2008-01-02 00:00:00 | 2009-01-02 00:00:00 | Name 7 | 2010-01-02 00:00:00 | 2011-01-02 00:00:00 | Name 8 | 2012-01-02 00:00:00 | 2013-01-02 00:00:00 | Name 9 | 2014-01-02 00:00:00 | 2015-01-02 00:00:00 | Name 10 | 2016-01-02 00:00:00 | 2017-01-02 00:00:00 | 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 | Name 4 | 2002-01-03 00:00:00 | 2003-01-03 00:00:00 | Name 5 | 2004-01-03 00:00:00 | 2005-01-03 00:00:00 | Name 6 | 2006-01-03 00:00:00 | 2007-01-03 00:00:00 | Name 7 | 2008-01-03 00:00:00 | 2009-01-03 00:00:00 | Name 8 | 2010-01-03 00:00:00 | 2011-01-03 00:00:00 | Name 9 | 2012-01-03 00:00:00
person 4 | Name 4 | 2000-01-04 00:00:00 | 2001-01-04 00:00:00 | Name 5 | 2002-01-04 00:00:00 | 2003-01-04 00:00:00 | Name 6 | 2004-01-04 00:00:00 | 2005-01-04 00:00:00 | Name 7 | 2006-01-04 00:00:00 | 2007-01-04 00:00:00 | Name 8 | 2008-01-04 00:00:00 | 2009-01-04 00:00:00 | Name 9 | 2010-01-04 00:00:00 | 2011-01-04 00:00:00 | Name 10 | 2012-01-04 00:00:00 | 2013-01-04 00:00:00 | Name 4 | 2014-01-04 00:00:00 | 2015-01-04 00:00:00 | Name 4 | 2016-01-04 00:00:00 | 2017-01-04 00:00:00 | 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 | Name 6 | 2002-01-05 00:00:00 | 2003-01-05 00:00:00 | Name 7 | 2004-01-05 00:00:00 | 2005-01-05 00:00:00 | Name 8 | 2006-01-05 00:00:00 | 2007-01-05 00:00:00 | Name 9 | 2008-01-05 00:00:00 |  | Name 10 | 2010-01-05 00:00:00 |  | Name 8 | 2012-01-05 00:00:00
person 6 | Name 6 | 2000-01-06 00:00:00 | 2001-01-06 00:00:00 | Name 7 | 2002-01-06 00:00:00 | 2003-01-06 00:00:00 | Name 8 | 2004-01-06 00:00:00 | 2005-01-06 00:00:00 | Name 9 | 2006-01-06 00:00:00 | 2007-01-06 00:00:00 | Name 10 | 2008-01-06 00:00:00 | 2009-01-06 00:00:00 | Name 6 | 2010-01-06 00:00:00 | 2011-01-06 00:00:00 | Name 6 | 2012-01-06 00:00:00 | 2013-01-06 00:00:00 | Name 6 | 2014-01-06 00:00:00 | 2015-01-06 00:00:00 | Name 6 | 2016-01-06 00:00:00 | 2017-01-06 00:00:00 | 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 | Name 8 | 2002-01-07 00:00:00 | 2003-01-07 00:00:00 | Name 9 | 2004-01-07 00:00:00 | 2005-01-07 00:00:00 | Name 10 | 2006-01-07 00:00:00 | 2007-01-07 00:00:00 | Name 7 | 2008-01-07 00:00:00 |  | Name 7 | 2010-01-07 00:00:00 | 2011-01-07 00:00:00 | Name 7 | 2012-01-07 00:00:00 | 2013-01-07 00:00:00 | Name 7 | 2014-01-07 00:00:00 | 2015-01-07 00:00:00 | Name 7 | 2016-01-07 00:00:00 | 2017-01-07 00:00:00 | 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 | Name 9 | 2002-01-08 00:00:00 | 2003-01-08 00:00:00 | Name 10 | 2004-01-08 00:00:00 | 2005-01-08 00:00:00 | Name 8 | 2006-01-08 00:00:00 | 2007-01-08 00:00:00 | Name 8 | 2008-01-08 00:00:00 | 2009-01-08 00:00:00 | Name 8 | 2010-01-08 00:00:00 | 2011-01-08 00:00:00 | Name 3 | 2012-01-08 00:00:00 | 2013-01-08 00:00:00 | Name 8 | 2014-01-08 00:00:00 | 2015-01-08 00:00:00 | Name 2 | 2016-01-08 00:00:00 | 2017-01-08 00:00:00
person 9 | Name 9 | 2000-01-09 00:00:00 | 2001-01-09 00:00:00 | Name 10 | 2002-01-09 00:00:00 | 2003-01-09 00:00:00 | Name 9 | 2004-01-09 00:00:00 | 2005-01-09 00:00:00 | Name 9 | 2006-01-09 00:00:00 | 2007-01-09 00:00:00 | Name 9 | 2008-01-09 00:00:00 | 2009-01-09 00:00:00 | Name 9 | 2010-01-09 00:00:00 | 2011-01-09 00:00:00 | Name 9 | 2012-01-09 00:00:00 | 2013-01-09 00:00:00 | Name 9 | 2014-01-09 00:00:00 | 2015-01-09 00:00:00 | Name 2 | 2016-01-09 00:00:00 | 2017-01-09 00:00:00
person 10 | Name 10 | 2000-01-10 00:00:00 | 2001-01-10 00:00:00 | Name 10 | 2002-01-10 00:00:00 | 2003-01-10 00:00:00 | Name 10 | 2004-01-10 00:00:00 | 2005-01-10 00:00:00 | Name 10 | 2006-01-10 00:00:00 | 2007-01-10 00:00:00 | Name 10 | 2008-01-10 00:00:00 | 2009-01-10 00:00:00 | Name 10 | 2010-01-10 00:00:00 | 2011-01-10 00:00:00 | Name 10 | 2012-01-10 00:00:00 | 2013-01-10 00:00:00 | Name 10 | 2014-01-10 00:00:00 | 2015-01-10 00:00:00 | Name 1 | 2016-01-10 00:00:00