1. A

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

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