Displaying Missing Sequence #s

[mandinko]

[TABLE="width: 269"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]List[/TD]
[TD]Start Number[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]End Number[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Missing Numbers[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]#NUM ![/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Here is my formula.
=SMALL(IF(ISERROR(MATCH($C$1+ROW(OFFSET($A$1,0,0,$C$2-$C$1+1))-1,$A$2:$A$9,0)),$C$1+ROW(OFFSET($A$1,0,0,$C$2-$C$1+1))-1),ROW(A1))

Why am I getting #NUM it should show 0, 8 and 9 right? The same formula is copied from B5 down. I can't get this thing to work for the life of me. Any Ideas Thanks in advance

 

[shift-del]

Mandinko,

this is an array formula. It must be entered with CTRL-SHIFT-ENTER instead of just ENTER.