Checking for overlapping numerical ranges

August 31, 2019

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.  

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com