Missing Number Ranges

Imagine someone is supposed to be listing a complete sequence of numbers, but they are only providing ranges (like 1-48, 49-79, etc.). The problem is to determine if there are any numbers missing between those ranges. We don’t need to list which numbers are missing, just to figure out if there’s a gap, a break in the sequence, anywhere in the provided ranges.

|Range Beginning|Range End|
|1|48|
|49|79|
|110|115|
|116|120|

That would be awesome if someone has some ideas to identify it

Here you go:

gaps.transform (5.0 KB)

Needed a little a bit of Javascript. But there might be a way to do it without.

Here is one idea.

Transform file.
MissingNumberRanges.transform (3.3 KB)

1 Like

thank you that is very helpful :slight_smile:

1 Like

thank you that is very helpful - awesome way to solve it