Question for the masters - is it possible to do such trick with random numbers in Excel?
I need to generate 40 random numbers from 1 to 40 placed in 9 rows. 5 rows with 4 numbers and 4 rows with 5 numbers, does not matter which rows. Numbers must be in their proper places by order of B1:AO1 .
Below is smaller example of wanted result of one block. Actually I need 96 blocks in one sheet - range B2:AO865
I need to generate 40 random numbers from 1 to 40 placed in 9 rows. 5 rows with 4 numbers and 4 rows with 5 numbers, does not matter which rows. Numbers must be in their proper places by order of B1:AO1 .
Below is smaller example of wanted result of one block. Actually I need 96 blocks in one sheet - range B2:AO865
Old5.xls | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | |||
2 | 1 | 9 | 11 | 14 | 15 | ||||||||||||||||||
3 | 2 | 2 | 5 | 6 | |||||||||||||||||||
4 | 3 | 7 | 12 | ||||||||||||||||||||
5 | 4 | 4 | 20 | ||||||||||||||||||||
6 | 5 | 10 | 18 | ||||||||||||||||||||
7 | 6 | 1 | 8 | 16 | 19 | ||||||||||||||||||
8 | 7 | 3 | 17 | ||||||||||||||||||||
9 | 8 | ||||||||||||||||||||||
10 | 9 | 13 | |||||||||||||||||||||
Sheet1 |