# permutations

1. ### Query for all possible permutations

Hi all, I work tagging iguanas with unique combinations of coloured beads for field identification. I have a table with 13 unique values corresponding to these bead colours (for example Db is dark blue, B is black, R is red, etc.). When an iguana is given a bead tag the order/number of the beads...
2. ### Permute values in one column

Hello, I have a list of values in column A such as A B C D E I want to output the list of permutations in column B for 2, 3 and 4 ways.: A. B B. A A, B, C A, C, B B, A, C A, B, C, D A, C, B, D B, A, C, D E, A, C, D Does anyone have any idea how it could be done in VBA? Thank you!
3. ### Excel permutations of columns VBA required

Hi I had a fully working Excel workbook that I found from an online tutorial, but the woorkbook has lost it's VBA code somehow. I have spent a lot of time online looking again including this forum, but could not find exactly what I need. If anyone could provide necessary code or point me to...
4. ### All Permutations of Three Variables

In order to generate all the permutations for three variables, put the variables in an Excel Table (which is called Inventory here). You can add as many rows to the Table as desired and you can fill in all or just one of the rows for each variable. The exemplar here will spill down 60 rows, the...
5. ### Combination of different cells

Needed a help on an excel scenario I have a column of say 3 rows containing numbers, Say A, B, C I need to generate a formula / code to give me sum of all possible number combinations.i.e. A + B A + C B + C A + B + C My real life scenario has more than 3 rows (actually about 15 rows)
6. ### Permutations of sets of values

Hello, I'm a new VBA user and really need some help. I'm trying to perform pairwise permutations of an undetermined number of values entered along a single row. The permutations should be exported into columns A and B in another tab. Then I want to repeat this process for the next and all...
7. ### How to count dates by month and day only

Hello I have a list of dates and am trying to count the number of instances that are, for example, 3rd of May irrespective of year. Is that possible? I tried the following, with various permutations for the year but didn't work: =COUNTIF(\$A:\$A,DATE(,5,3) Many thanks
8. ### VBA Help - Need to modify code to build a formula x amount of times

Hello all, I am working on creating formulas for a summary sheet and found a link to code that build permuations and its on the right track but I am not saavy enough to modify it. Here is the explanation. I have 2 columns, Column G is a for Prior Period, Column I is for Current. There is...
9. ### 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...
10. ### Horse racing treble permutations

Let's say I've selected 10 horses to bet on during a day and I would like to combine them into trebles covering all different permutations. There is more than 1 horse in each race that I want to bet on. For example, Race 1: Horses 6 & 9 Race 2: Horses 2, 4 & 7 Race 3: Horses 1, 3, 5 & 8 I know...
11. ### Reverse engineer prices in an Insurance Plan

Can some math genius please help me? I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions. Each of those three classes has three available variables: A, B and C. By clicking through the co's website, I was able to...
12. ### List all Permutations/combinations except duplicates

Please help, I need to generate rounds for security guards at multiple stations and I am looking to see if someone can help me using the code below to create a macro that would print only the unique permutations/combinations in sheet 2: For instance in sheet 1 my input would be the guards ID...
13. ### VBA macro to create unique permutations from different columns

Hi, I am trying to create a macro in VBA that takes data from three different columns and creates unique permutations while excluding any rows that have the same value in the first two columns. Example below; <thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align...
14. ### Creating groups of 6 numbers from list of 18 numbers

OK, I have a list of numbers, all of which are random. I am trying to create a non-repeating list of numbers in grouips of 6. I am trying to do this using VBA if possible. Number list 3 6 10 13 14 16 17 18 23 25 26 27 29 30 31 32 34 38 The ideal output for me would be: 3, 6, 10, 13, 14, 16...
15. ### Combinations & Permutations with Replacement (Repetition)

As I understand it, the combin & permut functions only calculate the results without replacement. There are no corresponding functions for with replacement. Is that correct? The formula for permutations with replacement is just n^k, but the one for combinations is ugly: (n+k-1)!/k!(n-1)!. Do I...
16. ### Generate combinatorials in Power Query

From a list I would like to generate combinations of n members from a set of x possibilities in Power Query. I have found some useful code here on creating combinations of members based on all possible values of n, and here on generating permutations for x, but I regret that I'm not good enough...
17. ### Return permutations of values that sum to a target - with constraints, repeats allowed

I'm trying to produce a list of number sequences, 4 numbers long that sum to a target value of 32. The constraints are that the numbers must be min = 0.5, max = 9. The numbers can only increment in 0.5. That is to say, I have a list of numbers (0.5, 1, 1.5, 2, 2.5, 3, etc............9). I need...
18. ### Shortcut for Permutations with Repetition

Hi all, in the excerpt of a code below I am trying to enter all permutations of 4 things. Is there a shortcut to do this without typing out all 256 permutations with repetition (4^4 = 256)? Thanks for your help! If Col = 1 Then Ary = Array (1, 1, 1, 1) ElseIf Col = 2 Then Ary = Array...
19. ### Modify a code to run all possible combinations

I have a code below that runs all possible combinations for as many columns as i have in sheet 1. the problem is that if i have a certain number of cells that would create more than 1,048,000 (excel line limit) different permutations, then the code will stop even though there could be more...
20. ### Permutations/combinations (VBA)

Hello all, I’m looking to create a macro that will output to excel “all weight” permutations for a portfolio of 2 assets. Now I’m actually looking to do this with quite a few assets (5 initially) but starting with 2 at this stage. To avoid too large a number of permutations, I will go up in...

### 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.

### Which adblocker are you using?

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

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