+ Reply to Thread
Results 1 to 9 of 9

Inputting all combinations

  1. #1
    Registered User
    Join Date
    01-12-2022
    Location
    brazil
    MS-Off Ver
    365
    Posts
    8

    Inputting all combinations

    Hello!

    I have been trying to figure out an easy way to do this. As my "real problem" is a bit confusing, I'll try to explain what I'm trying to do with dices.

    Let's say I have 5 dices, each with 10 sides, with numbers from 1 to 10. I want to get all possible combinations (100,000) in a spreadsheet, similar to what MarvinP provided in this thread: (cant link the thread yet... so excelforum.com/ excel-new-users-basics/1100218-how-to-input-all-combinations-for-6-dice.html)

    However, although I could change it to count up to 10 instead of 6, my real problem doesn't involves, necessarily, sequential numbers. My "dice" could have the following numbers, for example: 1, 3, 5, 6, 8, 10, 11, 13, 15, 19 (instead of 1, 2, 3, 4...).

    Is there any way that I could build a similar spreadsheet, but specifying the numbers of my dice?

    Thank you in advance!!

    - mucura
    Last edited by mucura; 01-12-2022 at 04:51 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Inputting all combinations

    Hi & welcome to the board.
    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-12-2022
    Location
    brazil
    MS-Off Ver
    365
    Posts
    8

    Re: Inputting all combinations

    I am, let's say, kinda newbie... for some reason when I place the formula into a cell, it returns me an error...

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Inputting all combinations

    What error do you get?

  5. #5
    Registered User
    Join Date
    01-12-2022
    Location
    brazil
    MS-Off Ver
    365
    Posts
    8

    Re: Inputting all combinations

    It just says that I have a problem with the formula, and points to:

    =CHOOSE(MID(BASE(SEQUENCE(10^5,,0),10,5),SEQUENCE(,5),1)+1,1,3,5,6,8,10,11,13,15,19)

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Inputting all combinations

    You may need to change the commas to semi-colons

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Inputting all combinations

    Have a look here
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-12-2022
    Location
    brazil
    MS-Off Ver
    365
    Posts
    8

    Re: Inputting all combinations

    It worked and it's exactly what I need!!! Thank you very much!!!

  9. #9
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Inputting all combinations

    You're welcome & thanks for the feedback.

+ 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: 0
    Last Post: 03-20-2021, 01:13 AM
  2. Needs help with inputting the formula in VB
    By jon151 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2013, 09:15 PM
  3. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  4. [SOLVED] Inputting the value Y, if there are two or more
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-02-2012, 12:56 PM
  5. Inputting Data
    By 2nice in forum Excel General
    Replies: 5
    Last Post: 09-30-2010, 05:43 PM
  6. Need Help Inputting Formula
    By siroky25 in forum Excel General
    Replies: 1
    Last Post: 07-31-2010, 01:26 AM
  7. Inputting question
    By sII000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2007, 01:59 PM

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