Get Missing Numbers
 

I have the following numbers in column A: 1, 3,4,5,7,8,10. I need a formula
that will provide the missing numbers in another column: 2,6,9. Thanks for
your assistance. rc

Get Missing Numbers
 

Try this ARRAY FORMULA, committed with CTRL+SHIFT+ENTER, instead of just
ENTER:

B1: =SMALL(IF(ISNA(MATCH(ROW(INDIRECT(MIN(A:A)&":"&MAX (A:A))),
A$1:A$51,0)),ROW(INDIRECT(MIN(A:A)&":"&MAX(A:A)))) ,ROW(A1))

Copy B1 into B2 and down until it returns errors.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"rc" wrote in message
...
I have the following numbers in column A: 1, 3,4,5,7,8,10. I need a
formula
that will provide the missing numbers in another column: 2,6,9. Thanks
for
your assistance. rc

Get Missing Numbers
 

Ctrl+shift+enter:
=SMALL(IF(ISNA(MATCH(ROW($1:$10),$A$1:$A$7,0)),ROW ($1:$10),""),ROW(A1))
then fill down


"rc" wrote:

I have the following numbers in column A: 1, 3,4,5,7,8,10. I need a formula
that will provide the missing numbers in another column: 2,6,9. Thanks for
your assistance. rc