View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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