for example, sequence of 5 digits (only 1,2,4,6,9). It's should be 55 sequences right? like this...

11111   11121   11141

11112   11122   11142

11114   11124   ...

11116   11126   ...

11119   11129   ...

next step, I want to call only the number that digit sum = 6, 8, 9

-------- 11121 11141

11112 -------- 11142

11114 11124 ...

-------- -------- ...

-------- -------- ...

If it cannot in be calculated in Excel, I will give up. lol

thank you in advance

More Chooseel Bunsuwansakul's questions See All
Similar questions and discussions