Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Any Excel wizards???

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


    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, Paid Member Posts: 11,203 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,957 ✭✭✭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