# combinations/permutations

1. ### All Combinations of Multiple Columns Without Duplicates

I have been searching for a code that does what I am hopeful is understandable to whomever may be able to help me with this. I have multiple columns with multiple names (10 columns in this case), some names are duplicated, and need to generate all possible combinations of these 10 columns of...
2. ### Impossible: 4 or 5 columns permutation with limit of 11 in VBA Excel

What I am looking for is impossible permutation combination I have been on this for sometime and cant seems to wrap a Excel vba around it. here goes. I have 5 columns each have a list of names( max limit of names per column is 50) First column a list of fruits Second column a list of...
3. ### Possibility Matrix

I have a question sheet which asks 4 basic questions. Then depending on the answers it gives the person a score. For Questions 1-3 the answer is a straight yes or no, then for question 4 the answer is Yes, no, maybe, not sure. What i want is a list of all combinations of answers so i can then...
4. ### Need to create a list of all possible combinations

I have a list of 50 unique values and I need to generate a full list of all possible combinations for these values - with the exception of like value to like value. Is there an easy way to do this? Example: Starting list AA BB CC Will generate a list of AA to BB AA to CC BB to AA BB to CC CC...
5. ### Finding Combinations of Values in a Two-Column List

Hi Everyone, I have a challenge that is failing to take root in my brain, and I'm hoping that someone will have a great idea, if not an actual solution. Here's my situation: I have a list of charitable membership (about 7000 people) and a list of projects that those members have expressed...

Hi All, I am currently in the idle of my MSc Dissertation and have a huge problem. I know what I need Excel to do for me but I have n idea where to start. I need to list all possible combinations of the following: six different categories of aircraft to which I have allocated the following...
7. ### Horse Racing Combinations - Trifecta (Without Macro)

Hello Everyone! Well, I am trying to gather all possible combinations for 10 horses for 3 place finishers. The 3 place finish is to illustrate a trifecta ticket. Example: 1-2-3 1-2-4 1-2-5 1-2-6 . . . 2-3-6 2-4-5 2-8-9 I understand for 10 horses, I should have a total of 720 combinations for...
8. ### How to display possible n combinations totaling x?

I was hoping to find a thread on this somewhere, but after a few hours of looking around without success, I decided to just post it here and hoping someone can help me out. I'm trying to display the total number of possible scenarios for my fantasy baseball auction draft. Here are the details...
9. ### permutations

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

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

### Which adblocker are you using?

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