Welcome Guest
You last visited April 20, 2018, 4:11 pm
All times shown are
Eastern Time (GMT-5:00)

# need help writing permutation macro

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

 Page 1 of 1
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.

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.