List of all possible 7 digit numbers between 1 and 20

[BlackCaiman]

Hi,

I have numbers from 1-20 in own cell and want to get a list of all number in 7 digits.
Is it possible to do that in excel?

 

[jasonb75]

There are no 7 digit numbers between 1 and 20, the smallest 7 digit number you can have is 1 million!

 

[BlackCaiman]

sry, I am a bit missunderstood.

I have numbers from 1-20 and I want all possible numbers but resault must be 7 numbers long (1,2,3,4,5,6,7; 1,2,3,4,5,6,8; 1,2,3,4,5,6,7,9;.....)

 

[BlackCaiman]

sry, I am a bit missunderstood.

I have numbers from 1-20 and I want all possible numbers but resault must be 7 numbers long (1,2,3,4,5,6,7; 1,2,3,4,5,6,8; 1,2,3,4,5,6,7,9;.....)

Mistake there in bold

 

[jasonb75]

Do you want combinations, or permutations?

To simplify it, do you want all possible orders of the same 7 numbers, or is 2;1;3;4;6;7;5 the same as 1;2;3;4;5;6;7 ?

 

[BlackCaiman]

Permutations

 

[jasonb75]

See if the workbook attached to this post helps.

https://www.mrexcel.com/forum/excel...-3-4-5-6-numbers-post3925622.html#post3925622

Bear in mind that 7 from 20 gives nearly 400 million permutations, so it will probably be very slow to run, that is assuming it works with a set that large.

 

[BlackCaiman]

Permutation post helped! Thx

Combinations should be less right? But as long as they dont repeat. You have anything for that?

 

[motilulla]

Please check under this link may help you
https://www.ozgrid.com/forum/forum/help-forums/excel-general/18812-permutation-combinations