permutations

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

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

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

Good morning, I am looking to code a macro that would essentially count out all the possible permutations of a data set. For example: Column A can be AA, AB, or AC. Column B can be either 0 or 1. Column C can be XX XY or XZ. Column D can only be 6. Is there any way for excel to read a sheet...

I've got a question with regards to combinations, which is: I need to create combinations (permutations) for the content in two columns, but I only want combinations specific to unique items in Column A (and the matching data in Column B). Here's an example: <tbody> 1234 ABC0 1234 ABC1...

Greetings all, Let's say I work at a company that builds machines with different model numbers. The most basic machine we build has 2 components. The most advanced has 6. Of these two most advanced types, we have 2 categories, A and B, so we make a super fancy A and a super fancy B. The store...

I have 8 questions (A - H) and 5 answers per question (1 - 5) - so a total of 40 possible answers. Using PERMUT(8,5), I know there are 6,720 permutations of answers. I now need to fill a matrix of 840 rows and 8 columns (Question ID) with the 6,720 permutations. I want to fill them with an...

Hi guys. Is it possible for us to process a combinatorics problem from Excel? For example, say I have 2 columns A & B. Column A contains 100 orders of quantities of items from 1-10 (with repetitions), and Column B contains rate per unit of that item. Let's say I set a parameter in which I say...

Hello all, I have a table with 6 columns (A to F) and multiple rows each. The cells contain words. Taking any non-empty cell from each of the columns in order from A to F will form a complete sentence each time. I need a solution to display all possible unique sentences in column G. The number...

Hi I have a list of 20 terminals with check boxes besides them and upon clicking each box several cost values show up in a table calculating the total costs associated with choosing that terminal. You can choose any combination of the 20 from 1 to 20 and the cost always displays in the same...

I have a set of Data as per below : Column A : Origin Country Column B : Destination Country Column C : export rate (doesnt mean actual rate here but an index) Now i have about 100 country names in column A and the same 100 in column B. different values for each lane export rate. Example...

Anybody, please help me. I am not good with VBA macros but I need to do a complete enumeration of number permutations :( Here's my problem. I have 8 objects--1, 2, 3, 4, 5, 6, 7 and 8. Each "solution" must contain all 8 objects, but the order matters. I need a macro that can generate all of...

Hi to everyone on this forum a few days ago I was looking for a code to generate 19683 permutations out of three letters abc and I found it here on mrexcel board RUGILA gave it to another member I only changed the letters anyway, I'm now trying to get another code to group all permutations...

I have phone scripts that can be built from 6 different categories. Each of the 6 categories has anywhere from 1 to 11 different scripts within them. I want to generate every possible script from these options, i.e: Part I: "Hi, as of 8am, on march 20th" Part II: "our records indicate 2...

Hello, I've tried to search for a solution to this problem, but I cannot seem to come up with one. Any help would be much appreciated. What I have is a list of 17 characters that I want to generate permutations for. Ultimately, I would like to generate permutations of five-member strings. For...

I'm not sure if this is possible, but... I'm trying to create all possible permutations for a string of keywords in a ell. For instance, Cell A1 contains: Black Air Max M200 Super Light Basketball Shoe So that's 8 words, and I need all possible 2, 3, 4, 5, 6, 7, and 8 word combinations in...

Hi, I was wondering if anyone could help me with a macro, haven't been able to find a solution so far. I have 5 numbers '1', '2', '3', '4', '5' in cells a1-a5. I want to find all the possible ways you can add 2 of these together. I want the macro to type the output into column C:D. So, for...

I have a major problem. I need a formula to come up with the combinations of balloons for my company. I have 5267 Yellow Balloons I have 5590 Pink Balloons I have 5127 Green Balloons I want them in 8 packs consisting of 3 of one color/3 of a second color/and 2 of the third. I have to...

I'm trying to model a somewhat complicated HR process where employees are allowed to voluntarily post to more preferred shifts and depts. I'm starting to thinking excel may not be the most effecient tool, but I can't back down from the challenge! Here's the situations--When there's a need to...

I am trying to create a list of permutations in a column for example I need a list of numbers 1-20 with no numbers repeating. This is causing my head to hurt and I have been working on this problem for some time. So any help would be much appreciated and is much needed.