I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Overlapping Ranges

You need a worksheet function to test for overlapping ranges?

20090913_overlapping_ranges

If adjacent ranges of time period may touch each other and if you want to see which range overlaps with others:

sbOverlap_Test

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 :-)

Sulprobil   Get it done   Contact   Disclaimer   Download