Maximum Number of Overlapping Intervals

Hi,

Sample data : "Updated Sample, post #5"
-Real data 100k+ row
-Decimal points number

Step:

1) Start count maximum number of overlapping intervals for "Row 2 Interval (C$2,D$2)" ,"=IF(MAX(D$2:D3)<=MIN(C$2:C3),1,"")" at row 3 to find out if "Row 3 Interval (C3,D3)" overlaps "Row 2 Interval(C$2,D$2)

2) If yes, continue to "Row 4 Interval (C4,D4)" so the formula become "=IF(MAX(D$2:D4)<=MIN(C$2:C4),1,"")"

3) Stop the formula when it return "" and count all "1". Sum of "1" place at Row 2, Column F.

4) Loop to next interval, start count maximum number of overlapping intervals for "Row 3 Interval (C$3,D$3)" , "=IF(MAX(D$3:D4)<=MIN(C$3:C4),1,"")"

5) If yes, continue to "Row 5 Interval (C5,D5)" so the formula become "=IF(MAX(D$3:D5)<=MIN(C$3:C5),1,"")"

6) Stop the formula when it return "" and count all "1". Sum of "1" place at Row 3, Column F.

.
.
.