combinations

Using Excel 2000 Hi, I got numbers in cell D5:Q7 distributed in the 3 rows 1 To 42 I need to make combinations picking 14 numbers out of 42 numbers these make combinations from Minimum sum with 287 and Maximum sum with 315 My query is how much combinations could be made with each of sum...

Hi all :bow:, I've had a look on the forum, but cant quite find what I'm looking for. So hopefully you can help! Here is an example: <colgroup><col span="3"></colgroup><tbody> A B C Org1 Org1 Org2 Org2 Org1 Org3 Org3 Org1 Org4 Org4 Org1 Org5 Org5 Org2 Org1 Org2 Org3 Org2 Org4...

Hi, I have the below code. I need to resize this to exclude the last row. In other words I want to keep all but the last row selected. Range("A3:B3").Select Range(Selection, Selection.End(xlDown)).Select I've tried various offsets and resize combinations and can't seem to get it...

Say I have the following in Column A A B C D E The number of rows in column A can be variable, With 5 values in column A, I can have 10 combinations like AB,AC,AD, AE,BC, BD,BE,CD,CE,DE I want to list list the combinations in column B , I am having problem with the loop, I used concatenation...

Hello all, I’m looking to create a macro that will output to excel “all weight” permutations for a portfolio of 2 assets. Now I’m actually looking to do this with quite a few assets (5 initially) but starting with 2 at this stage. To avoid too large a number of permutations, I will go up in...

Hi all! I could really use your help with my Excel file. It consists of rows of purchases, each row containing all the product numbers of 1 shopping basket. It looks something as following: Pr.1 Pr.2 Pr.3 Pr.4 Pr.5 Pr.6 Pr.7 Pr.8 ---> etc 100 101...

I am looking for a way to have excel list out all possible combinations where a few of the digits can be a variety of characters. See below example W P L 1 T 7 Q 9 3 B 2 R 0 P T P 6 T So each combination would be... WPL1T7Q93B WPL1T7P93B...

Hi there, Need some help with a formula for combinations of items. I have a list of items that are in groups like below: <colgroup><col width="56" span="2" style="width:42pt"> </colgroup><tbody> Group Item A Apple A Orange B Pear B Banana C Kiwi...

Hi everyone, I have a list of 7 possibilities (A,B,C,D,E,F,G) all of which can be combined with each other from being alone (A) to all 7 combined (A,B,C,D,E,F,G). Is there a way in excel to generate a list of all the possible combinations? Order does not matter. I think there should be about...

I am trying to make a spreadsheet that generates all possible player combinations that meet the requirements. The criteria are a 6 player lineup, each player has it's own individual salary, and a $50,000 lineup salary cap. I narrowed down the player pool to 20 players and each lineup must...

I have a matrix (14 rows and 5 columns): 1 | 2 | 3 | 4 | 5; --|---|----|---|--; 66| 67| 68 |69 |70. All elements are positive integers. I need to generate all possible combinations from the elements of this matrix. Each combination must contain 14 elements – one from each row. Sample...

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

Hi, I am trying to find a way to identify and display the combinations of 1,2,3,4,5,6 using 2 numbers, 3 numbers all the way up to 6 numbers, i.e. 2 numbers = 1,2 - 1,3 - 1,4 - 2,3 etc 3 numbers = 1,2,3 - 1,2,4 - 1,2,5 etc 6 numbers = 1,2,3,4,5,6 (I do not need 6,5,4,3,2,1 or any other...

Hello all, I'm having this problem with our company's products and what combinations are possible. The following is the situation: <tbody> CUSTOMER_ID PRODUCT_ID 1 A 1 B 1 C 1 D 2 B 2 C 3 A 3 B 3 E 3 F 3 G </tbody> I have specified for each customer what products they...

I've got a question with regards to combinations, which is: I need to create combinations (permutations) for the content in two columns, but I only want combinations specific to unique items in Column A (and the matching data in Column B). Here's an example: <tbody> 1234 ABC0 1234 ABC1...

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

<tbody> a (e,f) a (g,h) b (x,y) c (x,y,z) c (j,k,l) d (m,n) </tbody> From the table above: "a" can be matched with "e" or "f" or "g" or "h" "b" can be matched with "x" or "y" "c" can be matched with "x" or "y" or "z" or "j" or "k" or "l" "d" can be matched with "m" or "n" I need a...

So I have a really tough issue that I can't seem to wrap my head around. I have a list of players in each position QB, RB, WR, and TE. I need to pick 1 QB, 2 RBs, 3 WRs, and 1 TE from these lists, I would assume by using combinations. On top of this I want to be able to then limit the...

Hi All, I am trying to compile a list of optimal fantasy football lineups, but I am running into a duplicate issue. I am able to have 3 wide-receivers playing in my lineup. I identified what I think are the top 75 wide receivers and plugged them in to Access to find all 405,150 possible...

I need help with generating all combinations of 9 columns/groups of text. I have a sheet called "dinneroptions" and a sheet called "combinations". On the dinneroptions sheet I have (with headers): (Col A) Drink Water Tea Dr. Pepper Coke Diet Coke (Col B) Appetizer Bread Cheese Fries Garlic...