+ Reply to Thread
Results 1 to 5 of 5

Use Excel to build 7 digit number combinations

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Toronto Canada
    MS-Off Ver
    365
    Posts
    8

    Use Excel to build 7 digit number combinations

    I have a series of 9 numbers that I think are highly likely to be picked in a random draw. What formula can I use in excel to build 7-digit combinations of these 9 numbers so that every combination is selected?

    5,7,8,13,15,26,35,38

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,072

    Re: Use Excel to build 7 digit number combinations

    Do you mean that you want any 7 numbers out of the nine (although you have only listed 8 numbers)? It is confusing to refer to 7-digits, as a digit is a single number.

    Pete

  3. #3
    Registered User
    Join Date
    04-30-2019
    Location
    Toronto Canada
    MS-Off Ver
    365
    Posts
    8

    Re: Use Excel to build 7 digit number combinations

    The objective is to get every 7 number combination from the list of 9 numbers (5,7,8,13,15,26,35&38). The draw will only pick 7 numbers from the list of 9 (each number will not be replaced). Does that help?

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,043

    Re: Use Excel to build 7 digit number combinations

    Quote Originally Posted by Parka View Post
    The objective is to get every 7 number combination from the list of 9 numbers (5,7,8,13,15,26,35&38). The draw will only pick 7 numbers from the list of 9 (each number will not be replaced). Does that help?
    Did you read Pete's post? You repeat 8 number as list of 9 numbers.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

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

    Re: Use Excel to build 7 digit number combinations

    I am not aware of a single, simple formula for this kind of thing.

    It seems that most attempts at generating combinations/permutations involve nested For...Next loops.
    Please Login or Register  to view this content.
    I tried setting up a spreadsheet to do it with just spreadsheet functions here: https://www.excelforum.com/tips-and-...thout-vba.html It works pretty well for permutations. When I have thought about using this to generate combinations without repeats, I usually end up with something that generates every permutation then uses appropriate functions/logic to reject permutations that don't match the desired conditions. Recognize that, if pick 7 from 9 yields more than 1E6 possible permutations, it won't readily fit on a single tab/sheet because there are only about 1E6 rows to a spreadsheet (you may need to use multiple columns/tabs/sheets).

    It's not a specific solution to your specific scenario, but I would expect to adapt one of those approaches to your problem.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. 24 combinations for any 4 digit number
    By Ramya Sujesh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2020, 11:06 AM
  2. Replies: 3
    Last Post: 01-28-2016, 10:02 AM
  3. 6-digit combinations of numbers column A
    By Stoney1 in forum Excel General
    Replies: 2
    Last Post: 06-13-2015, 07:38 AM
  4. [SOLVED] Formatting to make 2 digit number show up at 3 digit number.
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 06:58 PM
  5. Finding Combinations of a Three digit Number
    By darrylx in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-08-2011, 05:29 AM
  6. Replies: 2
    Last Post: 09-23-2010, 11:12 AM
  7. 5 digit number combinations
    By Puppiie in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 09-02-2010, 05:02 PM

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