| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in overlapping date ranges (using array formula?) | Excel Worksheet Functions | |||
| How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
| Number sequence | Excel Discussion (Misc queries) | |||
| Number Sequence | Excel Programming | |||
| Identifying Overlapping Dates within a range | Excel Worksheet Functions | |||
Linear Mode
