# permutations/combinations

1. ### Generating a list of combinations (similar to Cartesian Product but more than 1 from each list)

Long time reader first time asker! I have a set of data and I am looking to generate a list of the combinations, I have found VBA and formulas but can't seem to get it right. It is similar to the Cartesian Product but rather than it being one from each list, there are multiples from each list...
2. ### How to display these combinations

<colgroup><col span="2"><col span="2"></colgroup><tbody> 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 6 6 6 6 7 7 7 7 8 8 8 8 9 9 9 9 </tbody> Code: Function ListPermut(num As Integer) 'Permutations without repetition Dim c As Long, r As Long, p As Long Dim rng() As...
3. ### VBA Task Order Permutations with constraints and compatibility

Good Evening, I am trying to create a list of logical schedule permutations. I have a list of 50 tasks, some can be done in parallel some may require other tasks to finish before they can begin. I am trying to write a VBA macro which goes generates a list of LOGICAL/FEASIBLE task order...
4. ### Limited Repeating Permutation Macro

I have found some threads that are close to this question, but none that I have been able to modify for my needs. The question is this: Say I have 3 object types a,b and c, where each has a quantity of x,y and z respectively. I need to load all of the possible permutations into a matrix (not...
5. ### Combinatorics problem (VBA code)

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...
6. ### How To: Permutations from columns with various data

I have to come up with a list of part numbers for my company and I have to come up with all the permutations for part numbers. I started to think that this was a simple manual task until I laid it out and realized the total number of permutations that would be listed. I'm asking for some help...
7. ### Permutation

Hi guys, I wonder if someone could help me with this query. I wish to get all the possible unique combinations out of this table. From Single column to Wireless/None column. So there should always be 7 combination for every turn. The order of these categories is very important so I can't have a...
8. ### Can I identify a specific permutation of responses to a survey and display it?

I very much appreciate any and all help in accomplishing this objective as follows: I have an online survey which has 9 list box questions. The only options for each question is "A" or "B". When the form is submitted I will have one row with some "9 column permutation" of "A's" and "B's". Each...
9. ### All possible combinations with repeats allowed

Hello Everybody, I'm looking for a way to have excel display (make a list) of all possible 9 digits/spaces combinations using three letters: CMU, where the letters can be repeated. I searched this forum and the internet. I've google it different ways and I still haven't figure out the answer...
10. ### permutations

I would like to make a function based off a number, that arranges the digits 1 through 9 in all possible combinations. Example: 1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 9 8 2 1 2 3 4 5 6 8 7 9 3 1 2 3 4 5 6 8 9 7 4 1 2 3 4 5 6 9 7 8 5 1 2 3 4 5 6 9 8 7 6 1 2 3 4 5 7 6 8 9 7 1 2 3 4 5 7...
11. ### Combinations

I want a formula to work out every 9-digit number, that uses only the values 1,2,3 and 4. (I don't mind having the numbers in separate cells) Like this: 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 4 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 2 3 1 1 1 1 1 1 1...
12. ### reverse distribution of excel totals

I have an Excel problem, that I need help with.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have the following table. I require 25 man days of work to be done at a given location. I calculate that I will need to make 10 visits to that...

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

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