How to structure the formula properly?

[ibmy]

Hi,

My objective is to identify (assign "1") the current row (interval) if it overlap from previous rows (intervals).
I have found the formula (thanks to these 3 sites : #1 , #2 , #3) but the problem is when there is a row (interval) that do not overlap (stop assign "1") and start new identify (assign "1")

Book1
	C	D	E	F	G
1	Start	End	Result		Explanation:
2	1.21716	1.21622
3	1.21706	1.21641	1		Formula start here, row $2 is locked since this row (interval) is overlap previous row (interval)
4	1.21733	1.21661	1
5	1.21686	1.21601	1
6	1.21754	1.21642	1
7	1.21777	1.21702			This row (interval) do not overlap all above intervals. Stop assign "1"
8	1.21477	1.21362			Start new identify (assign "1") if this row 8 (interval) overlap previous row 7 (interval). The problem is here, I cannot copy paste down formula that lock row $2 since row 7 stop assign "1"
9	1.21465	1.21401	1
10	1.21444	1.21367	1
11	1.21415	1.21360	1
12	1.21434	1.21362	1
13	1.21447	1.21340	1
14	1.21442	1.21402	1
15	1.21428	1.21331	1
16	1.21455	1.21332	1
17	1.21461	1.21423
Sheet1

Cell Formulas
Range	Formula
E3:E7	E3	=IF(MAX(D$2:D3)<=MIN(C$2:C3),1,"")

p/s : The data is minimum 1500 row, maximum 240k rows. Might consider vba code solution if formula solution works slow on 240k rows.

 

[GraH]

If it's intervals I would expect to see end values that are larger then start values. It never is the case in your sample?

 

[ibmy]

@GraH My bad, Column C is "End" and Column D is "Start"