combination

I'll make an example. I have three groups: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

I am attempting to create a form that will contain two selection options. Then, depending on the combination of selections, a specific dollar value is returned in a separate cell. For example, the user will choose from ComboBox1 either A, B, or C. Then they will choose from ComboBox2 either...

Need some help figuring out how to either make up equations or vba code to figure out 1200 combinations of 43 sets of words. What I am trying to do is merge the data into indesign on a bingo boards, 25 spaces and the center is common, so 24 boxes. I need 24 columns and each row would be made up...

I am looking to get a count of unique combinations from 3 cells. The order of the combination does not matter. So in below example the first two rows would be counted as the same combination. The other rows would be counted as different combos. 23 24 25 25 23 24 23 24 23 thanks!

I have 4 digit numbers in two columns. What I need to see is if the combination of them is being repeated below. So, if the number in column A is 1000 & column B is 1300, combination of them will be 10001300. Now I need to see if this combination or it's other reverse version (13001000) is...

I want to assign a macro to a keyboard shortcut, bit I don't want to clobber a key combination that is already assigned to something else. In Word, when I go to assign a keyboard shortcut, it tells me what that key combination is currently assigned to. Excel does not do that. Is there some way...

I have the following in column A starting at Row 1: A B C D E F I want the combination AB,AC,AD, AE,AF , BC,BD,BE,BF,CD,CE,CF,DE,DF,EF to appear in column B . I have no clue using VBA to solve this . Column A can have as much as 200 entries and therefore the solution should work for all...

I have 2 columns (A and B) and each column contains 6 items. I need combination of both columns which give sets of 6 items however combinations can only have 4 items from one column. Can anybody please help me.

Hi All! I have a table as shown below, and I need a solution (Excel macro) how to find all combinations of Values that when summed equal to Sum Needed <tbody> Names: Values: Name1 100 Name2 200 Name3 300 Name4 400 Name5 500 </tbody> Sum Needed: 1000 So, here 1000 can be reached in...

Hi All, I want to Extract all the words (comma separated) that start with specific combination of alphabets and numbers from a string. For example: if my string is as follows: 1) "My name is Sarad and my phone number is B023456 and the number of my car is B09876." Now I want all the words...

I have 7 rows, each row has the options "Low", "Medium", and "High". I need to combine all 7 rows so for example one possible combination would be "LLLLLLL", then "LLLLLLM", then "LLLLLLH", then "LLLLLML" and so on and so forth. The order does matter because each row represents something...

Trying to find all possible combinations with an excel function, also the data us additive? any ideas? 9 9 r r 81 81 82 82 84 84 85 85 86 86 so 99, 9r, 9r8, 9r82 but also need these to add onto each other, such as 9r81, 9r82, 9r84,..., 9r8182848586...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}span.s1 {text-decoration: underline}</style>Hello Mr.Excel Forum - What an amazing forum! I...

So I have 4 columns in this table: Color1 Color 2 Color 3 Color 4 Yellow Yellow Blue Blue Pink Pink Brown Brown White White Black Black SO my goal is to create all possible combinations without having duplicates. I was...

I'm trying to determine a way (maybe without VBA) to find the best combination of product for the price. It seems like this Knapsack formula I did some research on, but I was hoping for something in the existing formulas/solvers available standard in Excel. Any help is appreciated.

Hello, I apologise upfront if this is extremely confusing - i have struggled to put it into a nice clear format! however... I have 4 lists of data with each row containing two values; <tbody> Table 1 Val1 Val2 Table 2 Val1 Val2 Table 3 Val1 Val2 Table 4 Val1 Val2 First 52.3 0 First...

i want to create a table of combination of 8 letters of different ways what is the formula and how to create it ? i want the max combinations possible this is a small example: <tbody> a b c d e b a d e f c c a f g d d b a h e e c b a f f d c b g g...

First off, you guys rock. Secondly, I am clueless as to where to begin. So: I have 2 vans, each has seats for 14 people. Total seats: 28. I have 7 ticket prices: $15, $16, $17, $19, $21, $23, $24 My current reservation system is old enough to remember when Sun owned Java and ColdFusion was a...

Hi Everyone, I've been trying to get this to work this out for a while but am starting to struggle and am running out of time! I'm trying to optimise a running order for a show and am looking to generate all possible permutations of a possible running order with 28 acts. Below is an example of...

Ok so I currently have ran into a problem. I have generated multiple combinations and cannot find a way to remove the supplicates without removing several combinatons. For example: Red Red Plum Apple one two Red Red Plum Pear one three Red Green Plum Apple one two Red Green Plum...