number permutation formula

R

rally

hi,

is it possible using excel to show results of number permutations?
using some functions or macros or formula. eg if i enter a number 123,
results returned should be 321, 213, 132 etc..

thn
 
B

Bob Phillips

Rally,

Check out this previous post on a technique by Myrna Larson
http://tinyurl.com/273h5

If you put P in A1, 3 in A2, 1 in A3, 2 in A4, 3 in A5, and then run
ListPermutations. It will return 1,2,3 and 2,3,1 and 3,1,2 etc, but you can
strip the commas with =SUBSTITUTE(A1,",","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top