There is one issue, but we only encountered it after further testing and in fairness my examples didn't highlight this potential scenario.

Mark's solution assumes that the RangeId values are in...

Hi Mark,

Your solution is fantastic ... really ingenius ... thank you.

I had read about using OVER, but would not have thought of your approach in a long, long time.