All 10 digits possible combinations

[jmfer1]

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

[MarvinP]

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.

[jmfer1]

Hi MarvinP,

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

Thanks

[MrShorty]

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.