Array enter a formula like this (enter using Ctrl-Shift-Enter instead of just Enter) next to the
first value

=IF(ROW(A1)(MAX(A:A)-MIN(A:A)),"Enough",IF(ISERROR(MATCH(MIN(A:A)+ROW(A 1),A:A,FALSE)),MIN(A:A)+ROW(A1),""))

and copy down until the formula returns "Enough". You could then copy and paste values somewhere
else, and then sort to get rid of the cells that returned "".


HTH,
Bernie
MS Excel MVP


"lrxc" wrote in message
...
Can anyone tell me how to create a formula that will take a column of
invoices (just a numerical value like 108007) and display back the missing
numbers from that sequence?