I have two column sub range of natural number ( N ) :
col1 col2
0-2 12-13
7-11 18-21
20-25 28-30
tips: a-b is equal [a,b] in N
OK, I wanna compare each cell of col1 with all of cell in col2 and find intersect sub range,
for example ( 20-25 on col1 )
20-25 compare with 18-21 and get this result ( intersect ) : 20-21
or, you can suppose sheet to this form, too:
col1 col2 col3 col4
0 2 12 13
7 11 18 21
20 25 28 30
Bookmarks