+ Reply to Thread
Results 1 to 3 of 3

Permutations

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    USA
    MS-Off Ver
    I don't know, it was on the Mac I purchased, possibly 2011
    Posts
    1

    Permutations

    I have been searching this forum for hours looking for the answer to my question so I would not have to bother any of you kind folks, but to no avail, so if I offend anyone in any way with my stupidity, I will apologize in advance. I am using a Mac and my excel came with the hardware, so I am unsure of the Version, but the Mac is a 2011 machine if that helps.
    I am trying to find out how to create all permutation of 4 numbers, but using the numbers 0-9 as the input numbers. In other words, I want to generate all 4 number combinations of the numbers 0-1-2-3-4-5-6-7-8-9.

    thanx in advance
    kajabi

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,935

    Re: Permutations

    You might go to wikipedia or similar and look up the algorithm for generating permutations in lexicographic order, as this seems the most applicable algorithm. Basic idea is to start with the first iteration 0000 and change one digit at a time. so
    0000
    0001
    0002
    0003
    0004
    and so on

    Basically, you should get all of the integers from 0 to 9999, shouldn't you?

  3. #3
    Registered User
    Join Date
    02-22-2010
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Permutations

    EDIT : Ack, nix that, I completly misunderstood the request here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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