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.


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.