Why not insert a helper column and calculate the difference between the two
values.

"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?