+ Reply to Thread
Results 1 to 4 of 4

All 10 digits possible combinations

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    All 10 digits possible combinations

    Hey guys,

    Can you help me finding all the 10 digits possible combinations?

    Something like this: http://www.excelforum.com/excel-new-...binations.html

    I don't understand nothing at all but i really need it... hope to hear from you soon

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: All 10 digits possible combinations

    Hi jmfer1 and welcome to the forum.

    If you wanted a 3 digit number instead of a 10 digit, would 123 be the same as 321?

    Did you want Combination or Permutation? Read http://www.mathsisfun.com/combinator...mutations.html

    If the order matters there are about 3.6 million numbers and is more rows that Excel can handle.

    Please be more specific with your question and please give an example of how you want them and perhaps why.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-08-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: All 10 digits possible combinations

    Hi MarvinP,

    Combination... for now i need from 8000000000 to 8999999999 .. is that possible? If so, how?

    Thanks

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

    Re: All 10 digits possible combinations

    Algorithm wise, wouldn't you start with 8E9, then add 1, then add 1 to that, and so on until you reach (9e9-1)? That will require 1E9 cells. You have on the order of 1E7 cells per tab in Excel 2003, so you'll need on the order of 100 tabs in a workbook to generate all the numbers between 8E9 and 9E9. Unless I'm missing something, the algorithm isn't overly difficult, it's mostly a question of how much memory you have as to how many tabs you can have in a workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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