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.
Thank you all.
I am using Excel 2000
Regards,
Moti
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