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=551487

find missing numbers in a sequence
 

Depends what you mean by 'sequence'; 2,4,6,8 is a sequence, so is 5, 10, 15,
20 and then there is 1, 1, 2, 3, 5, 8....but I cannot spell Fibonacci!

If you mean a sequence where each value is the previous value plus 1:
With your numbers in A1:A8
In B2 enter =IF(A2=A1+1,"",A1+1&" missing")
Copy down the column

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kaytoo" wrote in
message ...

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=551487