combination

  1. R

    Bingo word boards random

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

    Count unique combinations

    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!
  3. M

    Show duplicate values for combination and it's reverse version

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

    How to display all of the current keyboard shortcuts

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

    Combinations listing

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

    Combination of 2 columns

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

    Excel Macro find all combinations of Values that equal to Sum Needed

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

    Extract all the words (comma seperated) that start with specific combination of alphabets and numbers from a string

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

    All possible combinations in 7 rows

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

    possible combinations

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

    Permutations and List Making with a variable - please help!!

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

    How to find all possible combinations of 2 identical sets of data without duplicates?

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

    Best Combination for the Price

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

    Combinations from Multiple lists

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

    combination of 8 numbers

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

    NEWBIE...be gentle

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

    Display All Permutations of a List Without Repeating Values

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

    Question about Removing Duplicates from a multiple combinations?

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

    How Can I merge these cells vertically?

    SO I have data on an excel spreadsheet that looks like this below, with one questions vertically after another. How do I merge the data per question separately? Please let me know! Thanks guys! #1 Whichofthe following is the paramount objective of financial reporting by state and local...
  20. N

    Combination with repetitions into excel for multiple data

    Hi guys! New tothe forum and first post for me, I tried to figure it out on my own and by looking on this forum, but not sure my mind is completely clear. I have to say I'm quite new to this kind of statistics, so apologize if the question is actually easy! I want to calculate the total...

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?

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
Back
Top