Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
What I am looking for is to select between 7 and 15 numbers in total, I want all the possible 6 digit combinations for this.<o></o>
<o> </o>
EG: if I choose 2,9,11,13,15,17&26, it would look something like this<o></o>
<o> </o>
2,9,11,13,15,17<o></o>
2,9,11,13,15,26<o></o>
9,11,13,15,17,26<o></o>
And so on.<o></o>
<o> </o>
If I chose more numbers (10) 1,2,3,4,3,6,7,8,9,10 it would start something like this<o></o>
<o> </o>
1,2,3,4,5,6<o></o>
1,2,3,4,5,7<o></o>
1,2,3,4,5,8<o></o>
1,2,3,4,5,9<o></o>
1,2,3,4,5,10<o></o>
And so on.<o></o>
<o> </o>
Please remenber I would like to be able to secelt between 7 and 15 number and be given all the possible combinations.<o></o>
I would like it to be in one sheet but if that can not be done on as many as it takes.<o></o>
<o>It would be good if I could just type the required number into A1,B1,C1 and so on and they just gave the combinations required.</o>
<o> </o>
Thanks in Advance<o></o>
<o> </o>
What I am looking for is to select between 7 and 15 numbers in total, I want all the possible 6 digit combinations for this.<o></o>
<o> </o>
EG: if I choose 2,9,11,13,15,17&26, it would look something like this<o></o>
<o> </o>
2,9,11,13,15,17<o></o>
2,9,11,13,15,26<o></o>
9,11,13,15,17,26<o></o>
And so on.<o></o>
<o> </o>
If I chose more numbers (10) 1,2,3,4,3,6,7,8,9,10 it would start something like this<o></o>
<o> </o>
1,2,3,4,5,6<o></o>
1,2,3,4,5,7<o></o>
1,2,3,4,5,8<o></o>
1,2,3,4,5,9<o></o>
1,2,3,4,5,10<o></o>
And so on.<o></o>
<o> </o>
Please remenber I would like to be able to secelt between 7 and 15 number and be given all the possible combinations.<o></o>
I would like it to be in one sheet but if that can not be done on as many as it takes.<o></o>
<o>It would be good if I could just type the required number into A1,B1,C1 and so on and they just gave the combinations required.</o>
<o> </o>
Thanks in Advance<o></o>