Hi All,
I am using Excel 2019 & have a requirement to shuffle a fixed set of numbers in column B so that they are greater than the numbers in column A.
The numbers in column B must only be all those numbers, (so a RAND function wont work) and must be all inclusive between 10 & 29 without duplication or a number missing.
Additionally the distance between the numbers in column A & B cant be greater than 20, i.e. the number in A1 is "1" and so the number in B1 cant be greater than "21", it must be between 2 & 20 etc..
I have played around with this without much success for a long time & now i need some help!!
I am using Excel 2019 & have a requirement to shuffle a fixed set of numbers in column B so that they are greater than the numbers in column A.
The numbers in column B must only be all those numbers, (so a RAND function wont work) and must be all inclusive between 10 & 29 without duplication or a number missing.
Additionally the distance between the numbers in column A & B cant be greater than 20, i.e. the number in A1 is "1" and so the number in B1 cant be greater than "21", it must be between 2 & 20 etc..
I have played around with this without much success for a long time & now i need some help!!
Number Shuffle.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | 1 | 10 | ||||||||||||||
2 | 2 | 11 | ||||||||||||||
3 | 3 | 12 | ||||||||||||||
4 | 4 | 13 | ||||||||||||||
5 | 5 | 14 | ||||||||||||||
6 | 6 | 15 | ||||||||||||||
7 | 7 | 16 | ||||||||||||||
8 | 8 | 17 | ||||||||||||||
9 | 9 | 18 | ||||||||||||||
10 | 10 | 19 | ||||||||||||||
11 | 11 | 20 | ||||||||||||||
12 | 12 | 21 | ||||||||||||||
13 | 13 | 22 | ||||||||||||||
14 | 14 | 23 | ||||||||||||||
15 | 15 | 24 | ||||||||||||||
16 | 16 | 25 | ||||||||||||||
17 | 17 | 26 | ||||||||||||||
18 | 18 | 27 | ||||||||||||||
19 | 19 | 28 | ||||||||||||||
20 | 20 | 29 | ||||||||||||||
21 | ||||||||||||||||
22 | ||||||||||||||||
23 | ||||||||||||||||
24 | ||||||||||||||||
25 | ||||||||||||||||
26 | ||||||||||||||||
27 | ||||||||||||||||
Sheet1 |