Welcome Guest
Log In | Register )
You last visited December 5, 2016, 7:43 pm
All times shown are
Eastern Time (GMT-5:00)

need help writing permutation macro

Topic closed. 1 reply. Last post 4 years ago by LottoBoner.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
cape girardeau
United States
Member #134854
November 8, 2012
1 Posts
Offline
Posted: November 8, 2012, 2:27 pm - IP Logged

I dont know how to write a macro in excel, need some help. when I write any number between 1 to 5 in cell(1, F) the macro should generate all the possible permutation. The numbers should come in differnt cell.

For example

If I enter 3 in cell(1, F)

outcome should start form cell(49, G) in this patern

1   1   2   2   3   3

2   3   1   3   1   2

3   2   3   1   2   1

 

all number should come in different cells.

Thank you in advance.


    United States
    Member #124493
    March 14, 2012
    7023 Posts
    Offline
    Posted: December 4, 2012, 11:44 pm - IP Logged

    I dont know how to write a macro in excel, need some help. when I write any number between 1 to 5 in cell(1, F) the macro should generate all the possible permutation. The numbers should come in differnt cell.

    For example

    If I enter 3 in cell(1, F)

    outcome should start form cell(49, G) in this patern

    1   1   2   2   3   3

    2   3   1   3   1   2

    3   2   3   1   2   1

     

    all number should come in different cells.

    Thank you in advance.

    ¿ΨΗÅΤ?What?