Find the missing number?
 

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

Find the missing number?
 

There 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.

Find the missing number?
 

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.

Find the missing number?
 

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" wrote in
message ...

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