Excel Forumula for Sequential Numbers

Originally Posted by Ferarri

The formula I'm using does not capture the missing numbers.

Sure it does. However, it won't return multiple results to a single cell. You have to return each result to its own cell (with that formula).

Data Range

	A	B
1	101	103
2	102	106
3	104
4	105
5	107
6	------	------

This array formula** entered in B1:

=IFERROR(SMALL(IF(ISNA(MATCH(ROW(INDIRECT("101:107")),A$1:A$5,0)),ROW(INDIRECT("101:107"))),ROWS(B$1:B1)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.