Formula to List Possible Numerical Combinations

[austin_mccully]

trying to get excel to list all possible number combinations of 123456 (EX: 123456, 123465, 123546, etc.) I could do it manually but it would take FOREVER... any suggestions of formulas to do so?

[Pete_UK]

Download jk_Eng from this site:

http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm

then you'll be able to do it quite easily.

Hope this helps.

Pete

[mike7952]

I dont believe you can with a formula but you van do this with a macro.

Please Login or Register  to view this content.