Excel Help--Don't know exactly how to, worried about feasibility.

[Bartender]

Maybe I'm thinking counter-productively, and you can correct me, but I was thinking the sequence 1,2,3,4,5,6,7,8,9,0 would continue:
1,2,3,4,5,6,7,8,0,9
1,2,3,4,5,6,7,9,8,0
1,2,3,4,5,6,7,9,0,8
1,2,3,4,5,6,7,0,8,9
1,2,3,4,5,6,7,0,9,8
etc.
And I have no idea how to do that.

[Ecniv]

So you want to have the ten numbers (0-9) and re-arrange them into all different combinations of those numbers?

hmmmmmm

First thought would be to start with one number, and move it through different positions, then move two numbers, then three numbers... But I don't think that would give you all the combinations.

How would you do it if you were doing it manually with say 4 or 5 numbers?
Make up a flow chart how you decided where to put the numbers to give you all the combinations.
Then convert that flow chart to code.

Another way would be an incremental count (cascading back through each position) with checks to make sure that the numbers are not repeated. Then if they are not repeated, you check against the last held total/combination and do the checks you want to see if it gives bigger/better result. Time consuming, but would probably work. Perhaps this is the initial way forward, then once working (so you can demonstrate it) then you can persue other routes?

Or you can end up...