Get Missing Numbers

[rc]

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

 

[Ron Coderre]

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)

 

[Bob Umlas, Excel MVP]

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