Try this program (full details inside):
http://www.savefile.com/files/7565212
File: Randomization_Lotto_program.xls
Think it fits the bill ..
The core functionality is driven via
the "RandLotto" UDF by Dave Hawley & JE McGimpsey
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"tx12345" wrote in
message ...
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 unique
numbers:
eg,
3 12 7 11 9
I will want the numbers not to change, so the 'set' of five randomly
produced numbers remains exactly the same.
Let's say , then, I will also want to produce 20 rows of said strings
of five. This way the cells automatically generate 20 sets of 5
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 numbers
shown above, and once produced they stay there fixed in the worksheet.
Thoughts?
TIA!
--
tx12345
------------------------------------------------------------------------
tx12345's Profile:
http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=399325