| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomize from a list
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Randomize from a list
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Randomize from a list
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Randomize from a list
I'm sorry.
I am building a spreadsheet using excel03 to consolidate my lottery club systems into one all inclusive workbook. One of the systems (which will be its' own sheet) is to select 15 numbers at random from 1-54. Then take those fifteen numbers and arrange them in combinations of six to buy the tickets from. I can do it by hand (and do) but it is very time consuming. So, I thought to automate it. Thanks for your patience -- Phil "Ragdyer" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Randomize from a list
checkout:
http://groups.google.com/group/micro...5d39b7d85d38cd -- Gary''s Student - gsnu200745 "PEGWINN" wrote: I'm sorry. I am building a spreadsheet using excel03 to consolidate my lottery club systems into one all inclusive workbook. One of the systems (which will be its' own sheet) is to select 15 numbers at random from 1-54. Then take those fifteen numbers and arrange them in combinations of six to buy the tickets from. I can do it by hand (and do) but it is very time consuming. So, I thought to automate it. Thanks for your patience -- Phil "Ragdyer" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Randomize from a list
Try Google, using
"lottery permutations" as the subject. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "PEGWINN" wrote in message ... I'm sorry. I am building a spreadsheet using excel03 to consolidate my lottery club systems into one all inclusive workbook. One of the systems (which will be its' own sheet) is to select 15 numbers at random from 1-54. Then take those fifteen numbers and arrange them in combinations of six to buy the tickets from. I can do it by hand (and do) but it is very time consuming. So, I thought to automate it. Thanks for your patience -- Phil "Ragdyer" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I randomize a list of names in excel? | Excel Discussion (Misc queries) | |||
| Randomize list of integers beteen 1-x with no repeats | Excel Discussion (Misc queries) | |||
| How do I randomize a list of 20 people? | Excel Discussion (Misc queries) | |||
| Need ideas to randomize list monthly? | Charts and Charting in Excel | |||
| How do I randomize a list without repeats | Excel Discussion (Misc queries) | |||
Hybrid Mode
