permutations/combinations

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

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

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

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

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

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

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

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

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

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

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

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