Spreadsheet: 739495d1625745535-max-number-of-cell-references-work-around-cell-reference-limit-2-2-
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 | First combination of items | Second Combination of items | Explanation behind Second Combination
Person 1 | Name 1 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | Name 2 | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | Name 3 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | Name 4 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | Name 5 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | Name 6 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | Name 7 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | =IF(D2<>"", IF(AND(C2>E2), IF(OR(E2<H2, G2=""), "D2", IF(OR(H2<K2, J2=""), CONCAT(D2, ", ", G2), IF(OR(K2<N2, M2=""), CONCAT(D2, ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(D2, ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2)))))), IF(OR(E2<H2, G2=""), CONCAT(A2, " & ", [NAME]), IF(H2<K2, CONCAT(A2, ", ", [NAME], " & ", G2), IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", [NAME], ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, " & ", [NAME]), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME])))))),"") IF(AND(F2<C2, OR(F2<H2, G2="")), "A2", IF(AND(C2<F2, OR(C2<H2, G2="")), "D2", IF(G2<>"", IF(AND(H2<C2, H2<F2), IF(OR(H2<K2, J2=""), CONCAT(A2, ", ", [NAME], " & ", G2), IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", [NAME], ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(G2<>"", IF(AND(H2=F2, H2<C2),  IF(OR(H2<K2, J2=""), CONCAT(A2, " & ", G2), IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(A2, ", ", G2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), ""))))),  IF(AND(H2=C2, H2<F2),  IF(OR(H2<K2, J2=""), CONCAT(D2, " & ", G2), IF(OR(K2<N2, M2=""), CONCAT(D2, ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(D2, ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2),""))))), IF(AND(H2=C2, H2=F2), IF(OR(H2<K2, J2=""), "G2", IF(OR(K2<N2, M2=""), [NAME], " & ", J2), IF(OR(N2<Q2, P2=""), [NAME], ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), [NAME], ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), [NAME], ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), IF(OR(W2<[NAME], Y2=""), [NAME], ", ", J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", [NAME]), "")))))),"") IF(AND(F2<C2, I2<C2, OR(AND(F2<K2, I2<K2), J2="")), A2, IF(AND(C2<F2, I2<F2, OR(AND(C2<K2, I2<K2), J2="")), [NAME], IF(AND(C2<I2, F2<I2, OR(AND(C2<K2, F2<K2), J2="")), G2, IF(AND(I2<C2, I2<F2), IF(OR(I2<K2, J2=""), CONCAT(A2, " & ", [NAME]), IF(AND(F2<C2, F2<I2), IF(OR(F2<K2, J2=""), CONCAT(A2, " & ", G2), IF(AND(C2<F2, C2<I2), IF(OR(C2<K2, J2=""), CONCAT(D2, " & ", G2), IF(J2<>"", IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", [NAME], ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", [NAME], ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]),"")), IF(AND(K2=F2, K2=I2, K2<C2),  IF(OR(K2<N2, M2=""), CONCAT(A2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(A2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), IF(OR(W2<[NAME], Y2=""), CONCAT(A2, ", ", J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", [NAME]), ""))))),  IF(AND(K2=C2, K2=I2, K2<F2),  IF(OR(K2<N2, M2=""), CONCAT(D2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(D2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(D2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(D2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), IF(OR(W2<[NAME], Y2=""), CONCAT(D2, ", ", J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", [NAME]), ""))))), IF(AND(K2=C2, K2=F2, K2<I2),  IF(OR(K2<N2, M2=""), [NAME], " & ", J2), IF(OR(N2<Q2, P2=""), [NAME], ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), [NAME], ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), [NAME], ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), IF(OR(W2<[NAME], Y2=""), [NAME], ", ", J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", [NAME]),""))))),  IF(AND(K2=I2, K2<F2, K2<C2),  IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", [NAME], " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", [NAME], ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", [NAME], ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(A2, ", ", [NAME], ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), "")))),  IF(AND(K2=F2, K2<I2, K2<C2),  IF(OR(K2<N2, M2=""), CONCAT(A2, ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(A2, ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(A2, ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(A2, ", ", G2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), "")))),  IF(AND(K2=C2, K2<I2, K2<F2),  IF(OR(K2<N2, M2=""), CONCAT(D2, ", ", G2, " & ", J2), IF(OR(N2<Q2, P2=""), CONCAT(D2, ", ", G2, ", ", J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(D2, ", ", G2, ", ", J2, ", ", [NAME], ", ", [NAME], " & ", S2), "")))), IF(AND(K2=C2, K2=F2, K2=I2), IF(OR(K2<N2, M2=""), "J2", IF(OR(N2<Q2, P2=""), CONCAT(J2, " & ", [NAME]), IF(OR(Q2<T2, S2=""), CONCAT(J2, ", ", [NAME], " & ", [NAME]), IF(OR(T2<[NAME], V2=""), CONCAT(J2, ", ", [NAME], ", ", [NAME], " & ", S2), IF(OR(W2<[NAME], Y2=""), CONCAT(J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", [NAME]), IF(OR(Z2<AC2, AB2=""), CONCAT(J2, ", ", [NAME], ", ", [NAME], ", ", [NAME], ", ", [NAME], " & ", Y2), "")))))),"")) | Would be Name 2 as Name 1 ends and Name 2 starts before other Names
Person 2 | Name 2 | 2000-01-02 00:00:00 | 2001-01-02 00:00:00 | Name 3 | 2000-01-02 00:00:00 | 2003-01-02 00:00:00 | Name 4 | 2000-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 3 & Name 4 | Name 3 and Name 4 because Name 2 ends before Name 3 and Name 4 end, meaning second combination consists of Name 3 and Name 4
Person 3 | Name 3 | 2000-01-03 00:00:00 | 2001-01-03 00:00:00 | Name 4 | 2000-01-03 00:00:00 | 2001-01-03 00:00:00 | Name 5 | 2000-01-03 00:00:00 | 2001-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 | 2013-01-03 00:00:00 | Name 10 | 2014-01-03 00:00:00 | 2015-01-03 00:00:00 | Name 3 | 2016-01-03 00:00:00 | 2017-01-03 00:00:00 | Name 3 | 2018-01-03 00:00:00 | 2019-01-03 00:00:00 |  | Name 6 | Name 6 because Name 3, 4 and 5 have ended at the same time and Name 6 starts before other Names
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 |  | Name 5 | Name 5 because Name 4 ended and Name 5 started before other names