# All 10 digits possible combinations

1. ## 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. ## 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.

3. ## 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. ## 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.

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

#### 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