Checking for overlapping numerical ranges


jdawson422 has posted a nice, easy, and useful Excel formula here, that you can use to check for overlapping ranges in a list of Bates numbers.

=OR(A1=A2,B1=B2,B1=A2,A1=B2,AND(B1>A2,B1<B2),AND(B2>A1,B2<B1))

The formula indicates when a numerical range listed in columns A and B overlaps with the range listed in the above row. It will give a "TRUE" result when the range overlaps with the previous one to various extents.