Devam Ediyor

Permutation Macro for Excel

I need a visual basic macro that will combine 4 lists into every permutation of the list. The data will be in 4 columns. And I'd need all combos of that data. The columns might have different lengths of data (ie column 1 might have 20 values, where column 2 only has 10, column 3 has 12, column4 has 3 values or something. Each one could change, of course.

Id need the output to be in a single column with spaces between each word in the permutation. Ouput should appear on the same sheet, underneath the 4 columns of original data. The outputed data should be selected for me so it's easy to copy without having to select everything. When running the macro, previous data would be removed so I don't have to do it manually.

If I had to guess, the outputted data would never exceed 200 rows. So no sort of excel sheet limit (if there are any) should apply.

Must work in excel 2007.

Beceriler: Excel, Visual Basic

Daha fazlasını görün: excel permutation, excel permutation macro, permutation excel, permutation macro excel, excel macro permutation, excel visual basic permutation columns, excel column permutation, permutation word excel, visual basic permutation, macro permutation excel, me excel, excel macro to word, limit permutation output excel, excel apply permutation, visual basic macro selected data, excel permutation macro list, excel permutation output, excel permutation values, permutation ouput macro, macro permutation, work on excel, Visual Basic Excel, sort excel, macro, macro excel

İşveren Hakkında:
( 12 değerlendirme ) Riverview, United States

Proje NO: #762392

Seçilen:

pyazlm

Message sent to PMB.

1 gün içinde 30$ USD
(32 Değerlendirme)
4.5

38 freelancer bu iş için ortalamada 50$ teklif veriyor

HussienSharaf

HI, I did many similar tasks. Plz check PM Hussien Sharaf

1 gün içinde 50$ USD
(48 Değerlendirme)
6.4
schandraram

Hello - My bid is for an Excel 2007 VBA script. Please send file with sample data. Thank you. Chandra Ram

1 gün içinde 90$ USD
(86 Değerlendirme)
6.4
MAnkita

Hello,Please refer your [url removed, login to view] you.

1 gün içinde 100$ USD
(76 Değerlendirme)
6.1
koolsidz

Please see PMB

in 0 gün içinde35$ USD
(100 Değerlendirme)
5.8
wsh2

Greetings Florida from Pennsylvania.. {smile} If I understand you correctly, I believe what you are after is combinations, not permutations. As such, your sample set of 20 x 10 x 12 x 3 will yield 7200 results and n Daha fazlası

1 gün içinde 44.95$ USD
(24 Değerlendirme)
5.4
ExcelGurus

Hello, Please take a look at your PMB. Thank you, David

1 gün içinde 50$ USD
(10 Değerlendirme)
5.0
dev3dworx

Please check PMB for details.

1 gün içinde 40$ USD
(19 Değerlendirme)
4.6
himanshuhc

Please refer PMB for sample.

in 0 gün içinde40$ USD
(14 Değerlendirme)
4.4
mike25

Please check PM for remarks

1 gün içinde 50$ USD
(14 Değerlendirme)
4.3
johnsinit

Dear Lorien! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

in 2 gün içinde68$ USD
(15 Değerlendirme)
4.0
YashpalSingh123

macro/excel professional, ready to start

in 2 gün içinde200$ USD
(2 Değerlendirme)
4.0
manishadk

Please check PMB

1 gün içinde 40$ USD
(11 Değerlendirme)
3.7
kaplar90

Please check PMB

1 gün içinde 30$ USD
(3 Değerlendirme)
3.5
ifaisal

I have lot of experience in writing Excel Macros. I can do this for you quickly and accurately.

1 gün içinde 50$ USD
(4 Değerlendirme)
3.3
vishalgoyal4

Hi Ready To Start.

in 0 gün içinde40$ USD
(1 Değerlendirme)
2.9
spiochu

Hello. I can do it.

1 gün içinde 30$ USD
(1 Değerlendirme)
2.8
zszabo

Hi, Please see PM. Zoltan

1 gün içinde 50$ USD
(3 Değerlendirme)
2.2
NeilSmith1962

Hi, You would be better off having the combined data in column "F" so you can copy the column quickly. You can have the result two hours after I see that my bid has been successfull. regards, Neil

1 gün içinde 30$ USD
(2 Değerlendirme)
2.2
win4t4

Hi, I can help you with this. There is 2 way of doing this. I can make you a macro to do this or I can make an array function. Which one do you prefer ? Winata

1 gün içinde 50$ USD
(1 Değerlendirme)
1.9
excelmodeler

Hi, I have done the work. Please see the attached file in PM. Thanks

1 gün içinde 100$ USD
(2 Değerlendirme)
1.4