Hi!

Assume the numbers are in column A.

Enter this formula as an array using the key combination of
CTRL,SHIFT,ENTER:

=INDEX(ROW($1:$700),SMALL(IF(COUNTIF(A$1:A$700,ROW($1:$700))=0,ROW($1:$700)),ROWS($1:1)))

Copy down until you get #NUM! errors meaning all the missing numbers have
been returned.

Biff

"Djanvk" <Djanvk.26vt7a_1146072000.9257@excelforum-nospam.com> wrote in
message news:Djanvk.26vt7a_1146072000.9257@excelforum-nospam.com...
>
> Is there a way to have excel find missing numbers in order?
>
> For example I have a list of 700 Numbers between 1 and 700, but do not
> have all the numbers in between the 1 and 700, is there a way to find
> which number I am missing?
>
> Thanks
>
>
> --
> Djanvk
> ------------------------------------------------------------------------
> Djanvk's Profile:
> http://www.excelforum.com/member.php...fo&userid=1548
> View this thread: http://www.excelforum.com/showthread...hreadid=536490
>