combinations/permutations

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

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

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

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

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

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

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

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