find missing numbers in a sequence
 

is it possible find missing numbers in a sequence?

example:
1
2
3
5
6
7
9
10

4 and 8 are missing.


--
kaytoo
------------------------------------------------------------------------
kaytoo's Profile: http://www.excelforum.com/member.php...o&userid=34057
View this thread: http://www.excelforum.com/showthread...hreadid=551488

find missing numbers in a sequence
 

Use conditional formatting:

If your data is in column A, select A2 and pull-down:
Format Conditional formatting... Formula Is and enter:
=(A2-A11) 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
--
Gary''s Student


"kaytoo" wrote:


is it possible find missing numbers in a sequence?

example:
1
2
3
5
6
7
9
10

4 and 8 are missing.


--
kaytoo
------------------------------------------------------------------------
kaytoo's Profile: http://www.excelforum.com/member.php...o&userid=34057
View this thread: http://www.excelforum.com/showthread...hreadid=551488