Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
one doozie of a macro req'd please...
Sounds like some type of lottery scheme. The probabilities of winning a
lottery are pretty well known. Regards, Tom Ogilvy ste mac wrote in message om... Hi Guys, l am new to this news group and was hoping somebody could help me out with some macro code... Picture the scene, l have in column A (rows 1 thru 10)a set of ascending numbers upto a maximum of 10 digits (there could be only 6, or 8 or 9 etc)... then the same in column B and C and D and finally E...so it looks something like this: ColA Col B Col C Col D Col E Ex: generated pairs triples quads 1 2 10 11 30 1-2 1-2-10 1-2-10-11 2 3 11 12 31 1-3 1-2-11 etc 3 4 12 13 32 1-4 1-2-12 4 5 13 14 33 - etc 5 6 14 15 34 - 6 7 15 16 - 7 8 16 17 8 9 17 18 33-34 18 19 There can be as many as 10 digits in any column and as low a 5 digits... now, what l would really like to do is list all the unique 'pairs' of digits that could be produced by all the digits in the range i.e 1-2...1-3...1-4 etc all the way up to 33-34... if this is not hard enough on its own, l need the triples! i.e 1-2-3...1-2-4...1-2-5 etc and to make matters even tougher l really need to quads to finish it off (oh no!!)yep! i.e 1-2-3-4...1-2-3-5... 1-2-3-6...1-18-19-32 etc etc... l know that quads alone will produce something in the region of 15 to 20,000 records...so even though l am asking a lot, l would like the results to be generated down a single column for the 'pairs' and another for the 'triples' and finally one for the 'quads'... l have to change the values in the columns once they have all been generated to run the process again with a different set of numbers in the columns, also l need something inbetween the generated numbers ie a "-"...The numbers in the columns will be from 1(min) to 34(max)... tough one? (nightmare!) Thanks in advance for any help gratefully recieved... seeya ste |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
one doozie of a macro req'd please...
I agree, but I felt like writing some code...
On Wed, 30 Jul 2003 23:14:19 -0400, "Tom Ogilvy" wrote: Sounds like some type of lottery scheme. The probabilities of winning a lottery are pretty well known. Regards, Tom Ogilvy ste mac wrote in message . com... Hi Guys, l am new to this news group and was hoping somebody could help me out with some macro code... Picture the scene, l have in column A (rows 1 thru 10)a set of ascending numbers upto a maximum of 10 digits (there could be only 6, or 8 or 9 etc)... then the same in column B and C and D and finally E...so it looks something like this: ColA Col B Col C Col D Col E Ex: generated pairs triples quads 1 2 10 11 30 1-2 1-2-10 1-2-10-11 2 3 11 12 31 1-3 1-2-11 etc 3 4 12 13 32 1-4 1-2-12 4 5 13 14 33 - etc 5 6 14 15 34 - 6 7 15 16 - 7 8 16 17 8 9 17 18 33-34 18 19 There can be as many as 10 digits in any column and as low a 5 digits... now, what l would really like to do is list all the unique 'pairs' of digits that could be produced by all the digits in the range i.e 1-2...1-3...1-4 etc all the way up to 33-34... if this is not hard enough on its own, l need the triples! i.e 1-2-3...1-2-4...1-2-5 etc and to make matters even tougher l really need to quads to finish it off (oh no!!)yep! i.e 1-2-3-4...1-2-3-5... 1-2-3-6...1-18-19-32 etc etc... l know that quads alone will produce something in the region of 15 to 20,000 records...so even though l am asking a lot, l would like the results to be generated down a single column for the 'pairs' and another for the 'triples' and finally one for the 'quads'... l have to change the values in the columns once they have all been generated to run the process again with a different set of numbers in the columns, also l need something inbetween the generated numbers ie a "-"...The numbers in the columns will be from 1(min) to 34(max)... tough one? (nightmare!) Thanks in advance for any help gratefully recieved... seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A REQ'D iNSTALLATION FILE ZF561407.CAB COULD NOT BE FOUND | Setting up and Configuration of Excel | |||
Formula Req'd - Autofilter limitation workaround | Excel Worksheet Functions | |||
Excel Inspect'n & Maintenance Record req'd under US DOT 396.3 | Setting up and Configuration of Excel | |||
date formula assistance req'd | Excel Worksheet Functions | |||
Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) |