I'm trying to dynamically generate a simple list of consecutive numbers, for example from 4 to 8000. The min and max values are calculated based on a separate list, but this list has gaps (e. g. 4, 5, 8, but 6 and 7 are missing).
My goal is to merge the two lists, and filter for the gaps, so in the example above I'd only get 6 and 7.
I wasn't able to dynamically generate the list, so I ended up creating one in Excel, but that seems like a fairly cumbersome (and unflexible) workaround.
Thanks for any help.