find missing numbers in a sequence

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top