Arrange the numbers as per box range

[motilulla]

Hello,

I need help to arrange 8 random number min = 1 max = 24 in the 6 boxes each box is filled with 4 numbers

For example in the cells C6:J6 I got 8 random numbers in ascending order i need to put them under each box with their corresponding value 2 & 3 go in the cell = M6, 5 & 7 go in the cell = N6, 13, 15 & 16 go in the cell = P6, 21 go in the cell = R6

With the same way row 7.... 8 & so on

For more detail the image is attached.

*	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1													Box-1	Box-2	Box-3	Box-4	Box-5	Box-6
2													1	5	9	13	17	21
3													2	6	10	14	18	22
4													3	7	11	15	19	23
5													4	8	12	16	20	24
6			2	3	5	7	13	15	16	21			2 | 3	5 | 7		13 | 15 | 16		21
7			1	2	6	7	13	17	18	19			1 | 2	6 | 7		13	17 | 18 | 19
8			2	7	10	11	18	20	22	24			2	7	10 | 11		18 | 20	22 | 24
9
10
11

Thank you all.

I am using Excel 2000

Regards,
Moti

 

[Fluff]

@Marc L there is no option for 2000 in the profile, the earliest option is 2007.

 

[JGordon11]

In case you upgrade to 365:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1													Box-1	Box-2	Box-3	Box-4	Box-5	Box-6
2													1	5	9	13	17	21
3													2	6	10	14	18	22
4													3	7	11	15	19	23
5													4	8	12	16	20	24
6			2	3	5	7	13	15	16	21			2 | 3	5 | 7		13 | 15 | 16		21
7			1	2	6	7	13	17	18	19			1 | 2	6 | 7		13	17 | 18 | 19
8			2	7	10	11	18	20	22	24			2	7	10 | 11		18 | 20	22 | 24
9
Sheet14

Cell Formulas
Range	Formula
M6:R8	M6	=TEXTJOIN(" | ",1,LET(X,MMULT(--($C6:$J6=M$2:M$5)*M$2:M$5,ROW($1:$8)^0),IF(X=0,"",X)))

 

[Marc L]

@Marc L there is no option for 2000 in the profile, the earliest option is 2007.

Ok thanks for this information, apologies to motillula !​