Welcome to my Web Pages
Cell Based Charts
Count Trailing Zeros
Increment Lowest Significant Digit
Minimum Truck Load Problem
Same Weekday and Calendarweek last year
Time Slicing According to REFA
You need a worksheet function to test for overlapping ranges?
If adjacent ranges of time period may touch each other and if you want to see which range overlaps with others:
Note: Please exchange ";" by ","!
In this example you array enter the formula into C2:C6 in one go.
You might prefer the simple Sumproduct formula =REPT("Overlap! ",SUMPRODUCT(--(A2<INDEX(D,,2)),--(INDEX(D,,1)<B2))-1) in C2 which you copy down :-)