AnsweredAssumed Answered

Generate a list of consecutive numbers

Question asked by Gert Wieland on Feb 15, 2018
Latest reply on Mar 8, 2018 by Gotn O'Guts

Hi community,

 

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.

Outcomes