Select the entire partial list in column a and give it a name.
([Insert] menu, selecting [Name] and then [Define])
For this example I chose the name 'par' for partial.
Enter '1001' in cell C1.
Enter the following formula in cell C2:
=IF(ISERROR(MATCH(C$1+ROW()-1,par,0)),C$1+ROW()-1,"")
fill down for 8070 rows
this will result in a list in column C that contains the numbers that are
not listed in column a, but there will be empty spaces in between the numbers.
to eliminate the spaces, select the entire column C
copy the entire column
with column C still selected, select [Paste Special] from the [Edit] menu
and select [Values] to replace the formulas in C with values
with C still selected, sort the column to move the cells with values to the
top of the stack.
Not pretty, but it works.



"SiH23" wrote:

In column A I have a series of numbers running from 1001 to 9078. These
numbers run in numerical order, but there are known missing values. For
example, the numbers may run 1000, 1001, 1005. In this instance the missing
numbers are 1002, 1003 and 1004. It is these missing numbers that I need to
identify from the column of numbers running from 1001 to 9078. Could these
missing numbers be placed in column C.

Any help would be greatly appreciated.