I have a sequence of numbers with a start range of 1 to 10,000.
In this column of 1 – 10,000 the numbers are sorted sequentially but in between some of the numbers are missing.
For example between 1 – 10,000, the numbers missing are 5, 120, 3000, 4500 and various other numbers. How do I build an excel formula to tell me what numbers are missing in this sequence.
I know there is a way to produce it using the VB code by using a FOR-NEXT-LOOP but is there a way to find the answer with using VB coding.
