find missing numbers in a sequence

[kaytoo]

is it possible find missing numbers in a sequence?

example:
1
2
3
5
6
7
9
10

4 and 8 are missing

 

[Gary''s Student]

Use conditional formatting:

If your data is in column A, select A2 and pull-down:
Format > Conditional formatting... > Formula Is and enter:
=(A2-A1>1) and pick a distinctive format


Copy cell A2 and paste/special format down the column.


Any hi-lighted cell is more than one away from the number above it