+ Reply to Thread
Results 1 to 6 of 6

Combination formula for selected numbers

  1. #1
    Registered User
    Join Date
    02-05-2023
    Location
    Pacific
    MS-Off Ver
    Microsofy Office Pro plus 2016
    Posts
    49

    Combination formula for selected numbers

    Hi, not sure if possible but will request here just incase someone can help.

    Is it possible to make an excel file that can automatically find all possible combinations from say 4 numbers.
    To explain fully, this has to do with horse racing. In one race possible of 24 runners and one venue possible of 10 races.
    I am only interested in running this exercise to show possible combination with 4 selections per race.

    Example
    Venue1
    Race 1 - 4,3,2,1
    Race 2 - 3,5,6,1
    Race 3 - 5,4,2,1
    Race 4 - 6,7,9,10
    Race 5 - 2,3,1,4


    Okay can the excel show all combination of all these selections?
    Thank you for your attention, and hopefully you can help.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Combination formula for selected numbers

    Is this still for Excel 2007?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-13-2022
    Location
    Kristianstad, Sweden
    MS-Off Ver
    2007/2016
    Posts
    21

    Re: Combination formula for selected numbers

    fintakol

    This is my contribution to a simple solution
    All the combination of 4 digits or 4 letters are well known.
    Data validation on the input cells, no duplicates.
    Sheets are protected with none code.
    Only tested on office 2007.
    Have a nice time with my Excel show
    /LGS
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-05-2023
    Location
    Pacific
    MS-Off Ver
    Microsofy Office Pro plus 2016
    Posts
    49

    Re: Combination formula for selected numbers

    Lars
    Thank you. FYI you said simple but to me you are a rocket scientist.
    Thank you very much for taking the time to respond to my request. I have looked at your sample and now realize that it is a big ask to do combination
    of 4 selections per race as it would be too many.
    This idea won't be worth the time as will be too costly.
    I thank you again. I will look at your sample and try to reduce the numbers to maybe 2 per race.

  5. #5
    Registered User
    Join Date
    04-13-2022
    Location
    Kristianstad, Sweden
    MS-Off Ver
    2007/2016
    Posts
    21

    Re: Combination formula for selected numbers

    You are welcome.
    I'm not a rocket scientist. It's simple mathematics. I'm using something called factorial of a number.
    If you GOOGLE Factorial you can read about it.
    Do this little trick to see how factorial expand
    in A1 put =ROW(), in B1 =A1&"!", in C1 =FACT(A1)
    Mark and drag column A, B, C down to e.g. 15.

    Happy New Year to all of you on the site.


    /LGS
    Last edited by LARS GULYAS; 01-05-2024 at 05:26 PM.

  6. #6
    Registered User
    Join Date
    02-05-2023
    Location
    Pacific
    MS-Off Ver
    Microsofy Office Pro plus 2016
    Posts
    49

    Re: Combination formula for selected numbers

    Lars
    Happy new year to you as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-23-2021, 02:03 PM
  2. [SOLVED] How to make the combination of numbers and total of that combination should be in range?
    By Darshan Shah in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 06-20-2020, 01:20 PM
  3. Formula to find closest combination of numbers ...
    By 951Michael in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2019, 04:09 PM
  4. Replies: 9
    Last Post: 11-19-2019, 05:28 AM
  5. Replies: 2
    Last Post: 11-11-2014, 04:01 PM
  6. Replies: 4
    Last Post: 11-20-2013, 10:16 PM
  7. [SOLVED] formula-combination of numbers
    By Armando Martellini in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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