Formula to find missing numbers.

[Trueblue862]

Hi,
I have a database with numbers between 1 and 750 in column "A". They are not in order and they aren't all there. Is there a way to get the missing numbers to show on another spreadsheet in numerical order? this way I can load them into a combobox on my userform.

 

[StephenCrump]

	A	B	C
1	N	20
2
3	MyNumbers		Missing?
4	3		6
5	8		11
6	10		14
7	7		15
8	9		16
9	17
10	4
11	5
12	2
13	20
14	19
15	12
16	13
17	1
18	18
Sheet2

Cell Formulas
Range	Formula
C4:C23	C4	=SORT(IF(COUNTIF(MyNumbers,SEQUENCE(N)),"",SEQUENCE(N)))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
MyNumbers	=Sheet2!$A$4:$A$18	C4
N	=Sheet2!$B$1	C4

 

[Trueblue862]

I'm missing something here. I am getting a NAME error with this formula. I probably shouldn't try and understand excel formulas 11 hours into a 12 hour shift.

 

[Trueblue862]

Never mind, I have figured it out. Thank you for your help.