« Blue Cross raises my group insurance by 13-25% each year. Is that enough or do they deserve more?
How do you write a query letter to a literary agent? »

Excel Formula 2 VIEW all comb 25 #s I select separted into 5 colums.Position not impt and each comb only once?

I am looking for the excel formula that will show me all combinations of 25 numbers I select that are separated into 5 colums. The position of the numbers is not important. For example: 1,2,3,4,5 is adequate for 1,3,2,4,5 or 1,4,2,3,5 etc. etc. I just need the 5 in a row used only once. The end goal is to plug in my 25 numbers I select into this formula and have excel produce all of the combinations for me to view. Thank you so much!

5 data making 120 permutation arrangements, like this
1234521345312454123551234
1235421354312544125351243
1243521435314254132551324
1245321453314524135251342
1253421534315244152351423
1254321543315424153251432
1324523145321454213552134
1325423154321544215352143
1342523415324154231552314
1345223451324514235152341
1352423514325144251352413
1354223541325414253152431
1423524135341254312553124
1425324153341524315253142
1432524315342154321553214
1435224351342514325153241
1452324513345124351253412
1453224531345214352153421
1523425134351244512354123
1524325143351424513254132
1532425314352144521354213
1534225341352414523154231
1542325413354124531254312
1543225431354214532154321

see vba macro example in my workbook at
http://www.box.net/shared/hg7crkehnx

This entry was posted on Wednesday, February 3rd, 2010 at 9:31 am and is filed under select into. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Excel Formula 2 VIEW all comb 25 #s I select separted into 5 colums.Position not impt and each comb only once?”

  1. 5 data making 120 permutation arrangements, like this
    1234521345312454123551234
    1235421354312544125351243
    1243521435314254132551324
    1245321453314524135251342
    1253421534315244152351423
    1254321543315424153251432
    1324523145321454213552134
    1325423154321544215352143
    1342523415324154231552314
    1345223451324514235152341
    1352423514325144251352413
    1354223541325414253152431
    1423524135341254312553124
    1425324153341524315253142
    1432524315342154321553214
    1435224351342514325153241
    1452324513345124351253412
    1453224531345214352153421
    1523425134351244512354123
    1524325143351424513254132
    1532425314352144521354213
    1534225341352414523154231
    1542325413354124531254312
    1543225431354214532154321

    see vba macro example in my workbook at
    http://www.box.net/shared/hg7crkehnx
    References :
    http://www.box.net/shared/hg7crkehnx

Leave a Reply