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