software

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: www.excelforum.com/member.php...foamp;userid=1548
View this thread: www.excelforum.com/showthread...hreadid=536490There may be better approaches, but one which you could use is to
create a list of the numbers in one spreadsheet, and use VLOOKUP from
that list to your target list to see which ones return no value.The best way I can think of would be to insert a new tab, and number
one of the columns from 1 to 700. Then perform a COUNT for each of
those numbers- this will tell you if a number is missing or duplicated.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

quot;Djanvkquot; gt; wrote in
message news
gt;
gt; Is there a way to have excel find missing numbers in order?
gt;
gt; For example I have a list of 700 Numbers between 1 and 700, but do not
gt; have all the numbers in between the 1 and 700, is there a way to find
gt; which number I am missing?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Djanvk
gt; ------------------------------------------------------------------------
gt; Djanvk's Profile:
gt; www.excelforum.com/member.php...foamp;userid=1548
gt; View this thread: www.excelforum.com/showthread...hreadid=536490
gt;