View Full Version : NUMBER ARRANGER
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?
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?
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
Nilem,
Downloaded the file.
Many thanks.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.