+ Reply to Thread
Results 1 to 3 of 3

6-digit combinations of numbers column A

  1. #1
    Registered User
    Join Date
    10-04-2014
    Location
    Netherlands
    MS-Off Ver
    Excel2010
    Posts
    6

    6-digit combinations of numbers column A

    Hi,

    I would like to make all 6-digit combinations possible from the numbers in column A.

    And i also would like to add/sum each combination if possible.

    See attachment
    Attached Files Attached Files

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,508

    Re: 6-digit combinations of numbers column A

    Hi.

    Do you realise that the number of different combinations of 6 numbers from the 990 you have in column A is more than 1 quadrillion, i.e.:

    1,287,912,126,756,260

    which would require more than 1 million columns to be fully populated in a standard Excel 2010 sheet, which would require just under 75,000 worksheets with every single cell fully populated?

    Good luck!!

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    10-04-2014
    Location
    Netherlands
    MS-Off Ver
    Excel2010
    Posts
    6

    Re: 6-digit combinations of numbers column A

    You are wright.

    I made a mistake. In the next example I have a square which represent all the combinations from the number 1 to 45, 8 million give or take.

    I would like to sum all these possible 6-digit combination.

    So say i have the combination 1-2-3-4-5-6 and this would add up to: (0.89+0.28+0.96+-1.5+-2.5) +(2.03+3.13+2.32+1.56)+(1.68+3,23+-2)+(-2.6+0.27)+(-2.1)

    I made it yellow in the attachment
    Attached Files Attached Files

+ 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. please help!!ALL COMBINATIONS REQUIRED FOR 5-DIGIT NUMBERs using numbers 0-9
    By natasha mirembe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 01:43 PM
  2. [SOLVED] macro to extract 9 digit numbers as well as alpha numberic 9 digit numbers from txt file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2012, 10:15 AM
  3. Replies: 1
    Last Post: 02-03-2012, 06:25 AM
  4. 5 digit number combinations
    By Puppiie in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 09-02-2010, 05:02 PM
  5. Generating combinations from a column of unique numbers
    By mistermat in forum Excel General
    Replies: 1
    Last Post: 08-31-2008, 06:54 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