Overlapping Sequence Number Range

L

LittlePenny

Is there a way for excel to detect that a number sequence range
overlaps. In the example below a sequence range is defined by column A
as the beginning number and column B as the end number. Can excel
detect that sequence range 22-45 overlaps with sequence range 11-25?




Column A Column B
Start Number End Number
1 10
25 45 Overlaps
46 75
11 25 Overlaps
76 100



Thanks




Little Penny
 
Top