All possible combinations from user input 6 digit number

Hi,

Hopefully this is a rather trival problem which can be solved easily - my limited excel knowledge just doesn't let me get anywhere near solving it.

I want to have a user input 6 digit number (e.g. 494241) from which I generate, and see, all possible permutations of digits (720 I believe).

My next stage is then to use this list of numbers as a lookup table to find the number permutation which is nearest to another user input numbers (e.g. 100000, 200000).

So for my two examples the final solution would be 124449 and 194442.

Hope this makes sense - any help is greatly appreciated.

Many thanks

Nigel

Hi, I've found this code from Myrna Larson: instructions ara quite clear.
Maybe it's a beginning to solve your problem.

The output of the macro can be adapted to your purposes.

http://www.ozgrid.com/forum/showthread.php?p=148992

Cheers