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

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!

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

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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