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