find missing numbers in a sequence

  • Thread starter Thread starter kaytoo
  • Start date Start date
K

kaytoo

is it possible find missing numbers in a sequence?

example:
1
2
3
5
6
7
9
10

4 and 8 are missing
 
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
 
Back
Top