Check If Numbers In Range (Dynamic Range)

Hi,

Visual how the data represent (Row 2 - 17):
Dynamic range is red line.

visual dynamic range_3.png

Sample data:
Data in Column D and expected result in Column E.
Explanation in Column G.

dynamic range_3.xlsb


Numbers in real data is decimal point, 3,5.
Total Row vary in each data, minimum 120, up to 330 000 rows.