Numbers ranging from eg 1 to 10 that do not appear in the selected range?

[malijela1]

Hello everyone,
How to find numbers ranging from eg 1 to 10 that do not appear in the selected range?
Which formula to write in H2, I2, J2..?

[TABLE="width: 209"]
<colgroup><col span="11"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mrhstn]

Here's one idea, I expect there will be a better solution.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N
2	9	2	4	4	2		1	3	5	6	7	8	10
3	5	4	5	5	7		1	2	3	6	8	9	10
4	6	5	6	6	4		1	2	3	7	8	9	10
5	4	6	6	2	7		1	3	5	8	9	10	#N/A
6	9	4	6	9	4		1	2	3	5	7	8	10
7	4	9	9	6	7		1	2	3	5	8	10	#N/A
8	7	6	2	7	6		1	3	4	5	8	9	10
9	6	5	7	2	6		1	3	4	8	9	10	#N/A
10	2	7	5	9	5		1	3	4	6	8	10	#N/A
11	5	9	4	4	4		1	2	3	6	7	8	10
Sheet2

Cell Formulas
Range	Formula
H2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:G2, ROW($A$1:$A$10)), 0))}
I2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:H2, ROW($A$1:$A$10)), 0))}
J2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:I2, ROW($A$1:$A$10)), 0))}
K2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:J2, ROW($A$1:$A$10)), 0))}
L2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:K2, ROW($A$1:$A$10)), 0))}
M2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:L2, ROW($A$1:$A$10)), 0))}
N2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:M2, ROW($A$1:$A$10)), 0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[malijela1]

My mistake, I did not mention that the selected range is from B2 to F11.

 

[mrhstn]

Gotcha, slight adjustment then

Book1
	B	C	D	E	F	G	H	I	J	K
2	9	2	4	4	2		1	3	8	10
3	5	4	5	5	7
4	6	5	6	6	4
5	4	6	6	2	7
6	9	4	6	9	4
7	4	9	9	6	7
8	7	6	2	7	6
9	6	5	7	2	6
10	2	7	5	9	5
11	5	9	4	4	4
Sheet2

Cell Formulas
Range	Formula
H2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:G11, ROW($A$1:$A$10)), 0))}
I2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:H11, ROW($A$1:$A$10)), 0))}
J2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:I11, ROW($A$1:$A$10)), 0))}
K2	{=INDEX(ROW($A$1:$A$10), MATCH(0, COUNTIF($B2:J11, ROW($A$1:$A$10)), 0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[malijela1]

Thank you very much.