Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Any Excel wizards???

  • 14-08-2013 11:35AM
    #1
    Hooked
    Registered Users, Registered Users 2 Posts: 2,918 ✭✭✭


    Howdy all

    I'm trying to generate a number sequence in Excel (I'm a graphic designer) so that I can generate 720 results for possible race finish of 6 greyhounds.

    ie
    123456
    123465
    123564
    123546

    and so on...
    6x5x4x3x2x1 = 720 variables

    I'm relatively familiar with Excel as we use it for mail merging, personalising data and writing numbering blocks for tickets, docket books, etc... but these are usually in sequence.

    This one has me stumped!


Comments

  • #2
    Fysh
    Moderators, Arts Moderators, Regional Abroad Moderators Posts: 11,172 Mod ✭✭✭✭Fysh


    There's a thread here for a similar query (only with more total possible combinations) that should hopefully cover you. The first page has two versions of a macro that should give you the general solution, the first post on the second page has comments to explain what the code does in case you need help understanding what to change.


  • #3
    Hooked
    Registered Users, Registered Users 2 Posts: 2,918 ✭✭✭Hooked


    Thanks Fysh... I'm more a software using designer than "coding" guru - but I'll see if I can wrap my head around that "macro".

    Thanks


  • #4
    Fenster
    Closed Accounts Posts: 4,763 ✭✭✭Fenster


    Seems like a straight permutation problem.


Advertisement