Forum Discussion
Solved
Overlap Formla by Criteria
Attached is the excel sheet. I just need to know what times overlap. Should be easy, however, I can have the same person on the same date. How do I tell excel to look at overlaps only when the nam...
Hi Cara,
Dates and times in file attached were presented as text, reformat to proper format. Formula for overlaps could be like
=IF(SUMPRODUCT((B2=$B$2:$B$7)*($J2>$I$2:$I$7)*(ROW(J2)<>(ROW($J$2:$J$7)))*(I2<$J$2:$J$7)*(D2=$D$2:$D$7)),"Yes","No")
and attached
Hi Cara,
Dates and times in file attached were presented as text, reformat to proper format. Formula for overlaps could be like
=IF(SUMPRODUCT((B2=$B$2:$B$7)*($J2>$I$2:$I$7)*(ROW(J2)<>(ROW($J$2:$J$7)))*(I2<$J$2:$J$7)*(D2=$D$2:$D$7)),"Yes","No")
and attached
This worked perfectly. Thank you so much!