+ Reply to Thread
Results 1 to 5 of 5

Pls help noobie generate a whole buncha permutations

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    2

    Pls help noobie generate a whole buncha permutations

    how can the permutations of 40 objects, 2 at a time, be generated, viewed and copied in excel 2003
    [ or in any permutation generator program ]?

    the 40 objects are: the 26 alphabet letters, plus ?, @, #, $, 0, 1, 2, 3, 4, 5, 6, 7, 8, and 9.

    on the monitor screen i want to view and copy the output of 1600 permutations of 2 objects each
    [ including, if possible, the "doubles?" like 'aa', 'bb'...'99' ]
    [ as if i were to do a matrix by hand, on paper, with the 40 objects across the top and also down the right side.
    the 1st few matrix cells would contain 'aa', 'ab', 'ac'... and so on thru to ... '97', '98' and '99' in the last few cells. ]

    i have moderate pre-calculus math skills. as a permutation noobie
    i've been seeking this unsuccessfully for several hours.

    I want to use this set of permutations to rank the frequency of sound occurrences in spoken english.

    And this will help me to better coach learners to improve their english pronunciation.

    thank you very much, in advance, for your kind help, in a more understandable "beginner level" explanation.

    kind regards n tyvm,

    yeehaw

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Pls help noobie generate a whole buncha permutations

    Hi, yeehawlm,

    welcome to ExcelForum.

    Please do not post the same question in different SubForums. Any answers please in this thread: http://www.excelforum.com/excel-gene...mutations.html. Thanks.

    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    05-15-2013
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Pls help noobie generate a whole buncha permutations

    'lo guru hahobe,

    just tried many times to delete earlier duplicate post n could not.

    in excel general retitled "delete attempted". best i could do.

    pls teach me how to delete a post.

    thanking you kindly i wish to remain yer respectful n obedient noobie,

    yeehaw

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,051

    Re: Pls help noobie generate a whole buncha permutations

    Only admin and mods can delete posts, but you dont need to delete it, just mark it solved - see my notes below
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    403

    Re: Pls help noobie generate a whole buncha permutations

    Here's your permutations.

    permutations for yeehawlm.xlsx

    More importantly, here's the quick and dirty code I used to generate the list:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1