PDA

View Full Version : NUMBER ARRANGER



wudi
11-23-2011, 08:50 PM
Hi,

I need an advise regarding number arranger in VBA. For example, I have inserted 123 in each cell and VBA output shall produce:-

132
213
231
312
321

Waiting your valuable advise.

Wudi.

mikerickson
11-23-2011, 09:04 PM
Will it always be three digits?

wudi
11-23-2011, 10:08 PM
up to 10 digits

nilem
11-23-2011, 10:16 PM
There's an example from YOSHIDA Hajime.
note that the number of permutations for example, 10 characters is 3,628,800.

mikerickson
11-23-2011, 10:17 PM
Will there ever be duplicate digits, e.g. 2423 ?
If so, do you want 2243 listed twice?

Will any numeral begin with 0 , eg. 043 ?
If so, it that to be treated differently than 43?

wudi
11-23-2011, 10:42 PM
mike
number listed shall be unique and will not begin with 0.

nilem,

I can't view your attachment.

nilem
11-23-2011, 11:15 PM
replaced the file
once again

wudi
11-23-2011, 11:36 PM
Nilem,

Downloaded the file.

Many thanks.