Overlapping Sequence Number Range
 

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

Overlapping Sequence Number Range
 

=If (B1=A1, "Overlaps","")


--
Steve

wrote in message
...


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