Hi,
I tried finding a solution for my issue in several topics, but I could not.
I have extracted from my table the first (lowest) and last (highest) values from a list with numbers. My columns are named respectively MIN - it contains the lowest value: 1800001315 and MAX - it contains the highest value - 1800001355. What i need generated in a separate column is the full sequence of numbers starting from 1800001315, 1800001316, 1800001317 and so on up to and including 1800001355. This is achieved in an extremely simple way in excel by the “sequence” formula. Here I end up needing Java Snippet (i have no experience with that and i do not understand what needs to be done).
For clarification, I need this full sequence in order to be then able to check which of the numbers in this sequence are actually missing in my full report.
So the idea is that if I have the full sequence, I will compare to my report and will check which ones are present there and what is missing.
If you can think of another way to identify the missing numbers within a sequence, that would not require generating the full sequence, I’d be grateful!
Thank you!
