Require missing 4 numbers list, from fix array numbers 1 To 14.

[motilulla]

Hello,

I need a formula if possible or a code, which can find 4 missing numbers from fix array numbers 1 to 14. There will be filled always 10 random numbers in the range B5:K5 (Between 1 to 14 numbers only 10 numbers) I need a 4 missing numbers list out of the array that is 1 to 14, in the range E1:H1

*	A	B	C	D	E	F	G	H	I	J	K	L
1					3	4	6	14
2
3
4		n1	n2	n3	n4	n5	n6	n7	n8	n9	n10
5		1	2	5	7	8	9	10	11	12	13
6
7
8

For example the sample image is attached.

Thank you all.

I am using Excel 2000

Regards,
Moti

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1					3	4	6	14
2
3
4		n1	n2	n3	n4	n5	n6	n7	n8	n9	n10
5		1	2	5	7	8	9	10	11	12	13
Main

Cell Formulas
Range	Formula
E1:H1	E1	=SMALL(IF(ISNA(MATCH(ROW($1:$14),$B$5:$K$5,0)),ROW($1:$14)),COLUMNS($E1:E1))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[motilulla]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1					3	4	6	14
2
3
4		n1	n2	n3	n4	n5	n6	n7	n8	n9	n10
5		1	2	5	7	8	9	10	11	12	13
Main

Cell Formulas
Range	Formula
E1:H1	E1	=SMALL(IF(ISNA(MATCH(ROW($1:$14),$B$5:$K$5,0)),ROW($1:$14)),COLUMNS($E1:E1))
Press CTRL+SHIFT+ENTER to enter array formulas.

Fluff, it is a precise formula for what I needed. I appreciate your help

Good Luck

Kind Regards
Moti

 

[Fluff]

You're welcome & thanks for the feedback.