permutations

  1. 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...
  2. 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)
  3. 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...
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. J

    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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. X

    Creating all possible combinations/permutations out of each row

    Hi all! I could really use your help with my Excel file. It consists of rows of purchases, each row containing all the product numbers of 1 shopping basket. It looks something as following: Pr.1 Pr.2 Pr.3 Pr.4 Pr.5 Pr.6 Pr.7 Pr.8 ---> etc 100 101...
  19. S

    List of Combinations of 7 different objects

    Hi everyone, I have a list of 7 possibilities (A,B,C,D,E,F,G) all of which can be combined with each other from being alone (A) to all 7 combined (A,B,C,D,E,F,G). Is there a way in excel to generate a list of all the possible combinations? Order does not matter. I think there should be about...
  20. T

    Need VBA Code for "permutations" and probablities

    Here is what i have and have wrote these formulas all the way to the 9th horse winning. Yea 3078 combinations and don't look forward to doing the remaining combinations. I'm Hoping someone could help me by sharing some code that would calculate this for me without writing another 3762 formulas...

Some videos you may like

This Week's Hot Topics

Top