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.
![](https://static.wixstatic.com/media/af7fa4_0a6434f84e1e45c4820a327d83457c95~mv2.png/v1/fill/w_82,h_62,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_0a6434f84e1e45c4820a327d83457c95~mv2.png)