Salaam,

Guys I am encountering a problem and looking for the solution. I am sure that I will get the positive reply from you.
The problem is that I have a different series of numbers in excel sheet and would like to find a number in the whole series that is missing in the whole series. Here I will explain my question in an example.

The series is as under.
1001
1002
1003
1005
1006
1007
1009
1012
1013
As you can see that, the series not ascending continuously. Some digits are missing like 1004, 1008, 1010, and 1011.
Now my question is that how can I trace the same thing with the help of a formula. Mean I would like to use a formula to check that what digits are not showing in the column.

Please note that original series is over 900 pages.