combinations in excel

i need vba codes for the below project. i have a list of 22 players from 2 teams like Name of Player Team Position Credits Bryan Team1 Bat 9.5 Daniel Team2 Bowl 8 Paul Team2 All 8.5 Wright Team2 Bat 10.5 Sam Team1 Bat 11 Suni Team1 Bowl 9 Sachin Team1 All 8 etc... i need...

I have a spreadsheet with 4 columns of data. I am trying to work out a formula to work out all possible combinations of the 4 columns. Each column has a different amount of data. It is text data. I had a working formula but Ive somehow broken it :mad: I want the output to contain all 4 of...

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 guys, I have a problem with combining different cells from 1 row. There's no need to create ALL possible combinations per row (reversed like: keyword1a & keyword1b + keyword1b & keyword1a) --> Just 1 of the 2 combinations is enough. Is there a proper way to do this? Basically this is what...

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

Hi everyone, Hope someone can assist me with this one. I am pulling together a report and i need to work out a formula from a changing input. For example If i am ordering 1 pallet of apples with 16 on a layer with 5 layers i would like a formula to say that if the order is in combinations of...

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 all, A B C .... N <tbody> 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 X X X </tbody> I am looking the combinations of X numbers from N columns but here is the hard part for me: After I generate the combinations from column A and...

Thank you in advance for any assistance you can offer. i'm trying to create excel (2007) spreadsheet that will list all possible combinations of 5 different groups of numbers, while filtering out some rows. Each of The 5 groups can contain between 1 and 8 possible numbers. for example: Group...

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 found a forum about generating all possible permutations using a formula. I started using it then realized I needed combinations because the order doesn't matter and I don't want an excess amount of combinations. Here is a link to that permutations post if you were concerned...

Hi, I am trying to write a formula (without Macros, queries, or VBA) to create all the combinations from a list, given certain conditions. I have several plants running several production lines, and if a production line breaks it has a cost as described below: <tbody> Factory Failure of the...

Hi, I have a very specific task at my Hand.. I have excel files which record purchase made for products daily at Prevailing market rates. I need to combine the sheets together. Each Excel file corresponds to the purchase made in a Particular Month and each tab within corresponds to the...

I have this problem that I am trying to resolve with Excel but I couldn't think of a solution. Does anyone know of a solution? Here is a simplified problem: Assume that you have two columns ... (Column1) (Column2) Dogs Cats Tom Marie Peter Lucy John How do you make it so...

I have 200,000 rows of data (ID#'s), columns G-Q have an offer code from a set of 300 possible offers. Each of the twelve offers in cells G-Q are different for each ID#. The offer numbers are not in numerical order. What formula would I use to calculate the number of offer combinations in the...

I have a set of Data as per below : Column A : Origin Country Column B : Destination Country Column C : export rate (doesnt mean actual rate here but an index) Now i have about 100 country names in column A and the same 100 in column B. different values for each lane export rate. Example...