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
Bookmarks