T
tx12345
Hi
Let's just say I have a series of numbers:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
And then let's say I want to randomly cull from that list 5 uniqu
numbers:
eg,
3 12 7 11 9
I will want the numbers not to change, so the 'set' of five randoml
produced numbers remains exactly the same.
Let's say , then, I will also want to produce 20 rows of said string
of five. This way the cells automatically generate 20 sets of
numbers with no duplicates within any string of 5
eg,
3 12 7 11 9
1 3 5 13 12
4 1 6 11 10
etc
with each string drawing randomly from the original set of 15 number
shown above, and once produced they stay there fixed in the worksheet.
Thoughts?
TIA
Let's just say I have a series of numbers:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
And then let's say I want to randomly cull from that list 5 uniqu
numbers:
eg,
3 12 7 11 9
I will want the numbers not to change, so the 'set' of five randoml
produced numbers remains exactly the same.
Let's say , then, I will also want to produce 20 rows of said string
of five. This way the cells automatically generate 20 sets of
numbers with no duplicates within any string of 5
eg,
3 12 7 11 9
1 3 5 13 12
4 1 6 11 10
etc
with each string drawing randomly from the original set of 15 number
shown above, and once produced they stay there fixed in the worksheet.
Thoughts?
TIA