Hi
Further to my earlier post concerning missing numbers and to the great help provided by zbor.
This the last post received and it works.
The above function writes the missing numbers in a new column.Write this formula in E10:
=IF(COLUMNS($E$10:E$10)<$C11-$C10,$C10+COLUMNS($E$10:E$10),"")
And pull it right and down as much as you need.
Notice that for example:
9154100
9154251
you need to go at least 151 column to the right...
Maximum is 256
I have a further question.
Is it possible to write the numbers into one cell so that I can then text wrap instead of
you need to go at least 151 column to the right...
Bookmarks