And it needs to be entered as an array formula with

Ctrl-Shift-Enter


"Duke Carey" wrote:

This works with a starting value of 1000 in cell A2, so that the integer
MINUS 998 = the Row#, and returns the row of the first nonconsecutive integer:

=MAX(--(A2:A28-998=ROW(A2:A28))*ROW(A2:A28))

"CM" wrote:

If I have a column of sorted consecutive Integers, can I search that column
and find cells that might be missing a consecutive Integer? We have a list
of customer numbers and if we don't have a number in the sorted sequential
order we want to be able to know that. Any help?