# permutation

1. ### VBA to list all Possible Permutations w/ conditional

I am looking for VBA code to list all possible permutations of the data below (will never exceed 20 #s), with the following caveats: Inputs needed: # of numbers used ("number_chosen") Conditional: If "Value" column is 0 then exclude from permutations So in the below would be, for example...
2. ### Combination And Permutation with no repeat

Thanks in advance in column "A", i have the numbers, suppose it is 0 to 99 (1) Now i want the list of generated numbers through combination with no repeats in the set of 5, please provide any vba code (2) I want the list of generated numbers through permutation with no repeats in the set of...
3. ### Get all possible permutations

Hello Team, I want to make all possible permutations of a name. I have a name like X Y Z and i have separate this name on the basis of space so now I have A1 - X B1 - Y C1 - Z In D1 I want to get all possible permutation of X Y Z for example X Y Z or Y X Z or Z X Y and so on.. or should be...
4. ### VBA how much permutation can be made using 3-digit with 0, 1 & 2

Hello,</SPAN></SPAN> I want to know is there any formula, which can count permutation can be made using 3-digit with 0, 1 & 2 </SPAN></SPAN> And a VBA, which can make all possible permutation, using 3-digit with 0, 1 & 2 using 7 cells with in the row which row sum must be =...
5. ### Combination of numbers in a range

Please help me to find a solution...I have populated column C and Column D with single numbers and Column E the numbers are concatenated. How do I generate a list of all possible COMBINATIONS of the Column E with all the other single numbers located in Columns C and D except numbers located in...
6. ### Require change to limit exact sum output combinations

Using Excel2000 Hi, Till now I was using "pgc01 code" which is amazing, I found code under this link https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848 I require modifications code only output Permutation Repetition with a desire sums For...
7. ### Permutations and List Making with a variable - please help!!

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}span.s1 {text-decoration: underline}</style>Hello Mr.Excel Forum - What an amazing forum! I...
8. ### Permutation problem

Hi - I would like to generate all the 5 digit long permutations that can be constructed from a pool of 30 unique digits. The pool of 30 digits are: 2, 3, 4, 6, 7, 8, 9, A, B, C, D, E, F, G, H, J, K, L, M, N, P, Q, R, T, U, V, W, X, Y, Z. [O, 0, 5, S, I, 1] are excluded due to the likelihood of...
9. ### Combination with repetitions into excel for multiple data

Hi guys! New tothe forum and first post for me, I tried to figure it out on my own and by looking on this forum, but not sure my mind is completely clear. I have to say I'm quite new to this kind of statistics, so apologize if the question is actually easy! I want to calculate the total...
10. ### How to generate all possible combinations with 2 sets??? please its urgent

Say there is a column with number 1,2,3,4 and 5 and there is another column with alphabets A,B,C,D now what I want is that each number combine with a alphabet such that for same combination no other number occupy the previous alphabet. For example. Combination 1: 1A - 2B - 3C - 4D (if a...
11. ### VBA Permutate Different Strings

Netizens, Let's say I have a row filled with three different strings: <tbody> Dog Cat Mouse </tbody> How do I create a permutation algorithm that will generate the following outputs? Thanks in advance! <tbody> Dog Cat Mouse Dog Mouse Cat Cat Dog Mouse Cat Mouse Dog Mouse Cat Dog...
12. ### Permutations of Set of Numbers in a Column

I have searched all over the internet but am having trouble finding the answer to my problem. I would like to write a macro that will list the possible permutations of a column, in the column right next to it. For instance, see columns 1 and 2: <tbody> 1 1 Permutation1 2 2 Permutation1 3 3...
13. ### Permutations or Combinations from sets of numbers

I have searched all the forms to try and find a solution for this. I have found lots of permutation algorithms - have even written a few but I cannot figure out how to do this. I have x set of groups that have x numbers in each group. For example group1(1,2,3,4) group2(2,4) group3(1,2,4) I...
14. ### Permutation

Hi guys, I wonder if someone could help me with this query. I wish to get all the possible unique combinations out of this table. From Single column to Wireless/None column. So there should always be 7 combination for every turn. The order of these categories is very important so I can't have a...
15. ### Replicating data from a list

Hi, I have 2 lists: [Note: Treat the commas as separate columns] LIST A: loc1 lo-2 loo3 loi4 LIST B: 1,abba,75 2,babba,356 3,bom,22 Final Product Required: 1,abba,75,loc1 2,babba,356,loc1 3,bom,22,loc1 1,abba,75,lo-2 2,babba,356,lo-2 3,bom,22,lo-2 . .. ... .. 3,bom,22,loi4 So basically...
16. ### Combinations (Groups of 10 from 13 digits)

I am using Excel 2003 (xls file). My problem is similar to many permutation/combination problems but I looked at the other threads and could not find a way to apply the solution to my problem (I am not very Excel-competant, sadly). I have 13 objects that I am using labels (A,B,C, etc) for. I...
17. ### Listing permutations of multiple cells(text&numbers) in sequence.

I'll try to explain myself, please bear with me. I have four list, shown below, that i need all the permutations/combinations in sequence: YearMonth,Number,Location. Example: 20071,102,Vietnam......"blank"12,104,Canada....and so on. Hope thats clear enough. Thanks in advance. <TABLE...
18. ### Stringing together combinations of two

I'm fairly inexperienced with excel, so I may need a lot of help. This also may not be possible with excel. Here I go: I have a 2-column list of words that I know must go together in order. The columns looks like this: bar graph bell pepper bell service board room car door car pool trail...
19. ### Generating permutations on three factors

Afternoon all. I attempting to generate a list of possible permutations based on 3 possible factors (one factor of 227 possibilities, a second factor or 8 possibilities and a final factor of 25 possibilities). The combinations are starting to blow my mind a little. As a brief example I'm...
20. ### Generate permutation of 12 Characters in Excel

I have no clue about permutation jargon so in the simplest possible lay man terms can someone talk me through how to generate all the possible permutations/sequence for the following twelve characters. 2Q3QS7ULVJY1 Many Thanks 2ray.

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back