+ Reply to Thread
Results 1 to 4 of 4

Listing permutations

  1. #1
    Forum Contributor
    Join Date
    11-14-2009
    Location
    Midwest
    MS-Off Ver
    Excel 2003/2007
    Posts
    103

    Listing permutations

    I am trying to find a way to list out all the permutations of 1 2 3 4 & 5 in 5 digit sequences. I know there are 120 permutations, but how do I list them all out in Excel?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Listing permutations

    This site will do that for you:

    http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm

    Download the file (it's safe) and then use it. You can look at the macros in it if you wish.

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363

    Re: Listing permutations

    nice one Pete_UK
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

  4. #4
    Forum Contributor
    Join Date
    11-14-2009
    Location
    Midwest
    MS-Off Ver
    Excel 2003/2007
    Posts
    103

    Re: Listing permutations

    Thanks Pete_UK, that's great.

+ 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