Generating numbers from a number list
Hello all,
New to the board. I would like help with coming up with a formula which will help me generate
5 two digit number groups.. yes, this is lottery related... lol.....
anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 50 numbers.
numbers in the list could be any number between 01 to 60, never higher then 60. So it could look like this:
12
10
09
03
11
14
02
05
19
14
06
on down....
From this list I would like to generate sets of 5 2 digit groups, like this:
02 03 09 11 14
02 05 11 14 19
02 05 11 12 19
I would like a box or drop down option where I could select the how many number groups are generated, 5, 10, 15, 20, and if possible, generate the maximum possible variations of those numbers from the list.
Thank you for any help offered.
Dave
