Randomize from a list
AGAIN ... What 15 numbers?
I only know of 10 digits, 0 to 9.
If you're referring to double or triple digits, how does that compute to a
*6 digit* number?
Or, are you not referring to a 6 *digit* number, but to 6 numbers of *any*
number of digits, as in a combination to a safe?
Need a better description for this old brain to start working.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PEGWINN" wrote in message
...
I have a list of fifteen numbers in a row A1:A15 (using Excell 03)
I want to populate a "table"from those fifteen numbers in groups of six
until all possible combinations are created.
Out put would look something like this:
1 2 3 4 5 6
1 3 4 5 6 7
etc
HTH-- Thanks -- Phil
"Ragdyer" wrote:
Don't quite follow.
What 15 numbers?
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"PEGWINN" wrote in message
...
I am trying to create a random mix. The idea is to create as many
unique
six
digit combinations from a field of fifteen numbers as possible. I
looked
at
Rand and some other formulas and they just don't quite get it done.
Thanks.
-- Phil
|