Spreadsheet: 275033d1383315083-take-whole-parts-of-a-list-table-based-on-one-criteria-take-from-list
Sheet: Sheet1

Person | Contract Nr. | Start date | End date | Month | Product
Christian | 1 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00 | 12 | A
Christian | 5 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
Christian | 6 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00 | 12 | A
Christian | 8 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
Christian | 15 | 2012-01-01 00:00:00 | 2012-01-30 00:00:00 | 0 | B
Christian | 35 | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 | 0 | B
Christian | 68 | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 | 1 | B
Christian | 4 | 2011-04-04 00:00:00 | 2013-03-31 00:00:00 | 24 | C
Christian | 55 | 2011-04-03 00:00:00 | 2012-03-31 00:00:00 | 12 | B
Christian | 3 | 2011-04-03 00:00:00 | 2012-03-31 00:00:00 | 12 | B
Christian | 21 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | B
Christian | 35.5818181818182 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00 | 12 | A
Christian | 38.1636363636364 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
Christian | 40.7454545454545 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00 | 12 | A
Christian | 43.3272727272727 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 45.9090909090909 | 2011-04-04 00:00:00 | 2013-03-31 00:00:00 | 24 | C
[NAME] | 48.4909090909091 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00 | 12 | A
[NAME] | 51.0727272727273 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 53.6545454545455 | 2011-04-03 00:00:00 | 2012-03-31 00:00:00 | 12 | B
[NAME] | 56.2363636363636 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | B
[NAME] | 58.8181818181818 | 2013-04-01 00:00:00 | 2014-03-01 00:00:00 | 11 | B
[NAME] | 61.4 | 2013-04-01 00:00:00 | 2014-03-31 00:00:00 | 12 | A
[NAME] | 63.9818181818182 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 66.5636363636364 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 69.1454545454545 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 71.7272727272727 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 74.3090909090909 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 76.8909090909091 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 79.4727272727273 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 82.0545454545454 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 24 | A
[NAME] | 84.6363636363636 | 2011-04-03 00:00:00 | 2012-03-31 00:00:00 | 12 | A
[NAME] | 87.2181818181818 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 89.8 | 2013-04-01 00:00:00 | 2014-03-01 00:00:00 | 12 | A
[NAME] | 92.3818181818182 | 2013-04-01 00:00:00 | 2014-03-31 00:00:00 | 12 | B
[NAME] | 94.9636363636363 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | B
[NAME] | 97.5454545454545 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | B
[NAME] | 100.127272727273 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | C
[NAME] | 102.709090909091 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | B
[NAME] | 105.290909090909 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 24 | B
[NAME] | 107.872727272727 | 2011-04-03 00:00:00 | 2012-03-31 00:00:00 | 12 | B
[NAME] | 110.454545454545 | 2012-04-01 00:00:00 | 2013-03-31 00:00:00 | 12 | A
[NAME] | 113.036363636363 | 2013-04-01 00:00:00 | 2014-03-01 00:00:00 | 12 | A