My question concerns a similar issue regarding the PERMUTATION command.
Specifically is it possible to use this command with multiple "R's?" The
first argument is N and represents the number of choices. The second argument
represents the types of choices or groupings. In some cases the R can have
several values, such as R1=4, R2=3. In these cases I have found I can only
compute the permutation by using the mathematical formula.
--
Jim


"RobN" wrote:

I have a 6 digit number (1-6) and no number is repeated. Is there a formula
or other VBA function that will permutate that number (ie scramble or
interchange the digits), either once off or, preferably, rearrange them in
every possible way.

Rob