Alright, now I understand what you want. I think I can come up with a simple solution a bit later (no time right now), but there seems to be still an inconsistency in your description of the requirement.

In paragraph 2, your ranges are 150-250, 200-300, 250-350..., i.e. with an increment of 50 and an overlap between successive ranges.

In the expected outcome you show, your ranges are 150-250, 250-350, 350-450..., i.e. an increment of 100 and no overlap.

Can you please clarify?