combinations

Hi everyone, I have a tricky task :) Let me clarify that step by step below. Input table with 5 columns columns are: combination, place1, place2, place3, income column combination represents a number of each combination (combination of 3 places) place1, 2, 3 are basically points where a car...

Hi I found this earlier post about finding the most common combinations of 3 in a worksheet: https://www.mrexcel.com/forum/excel-questions/898307-find-most-common-combination-3-a.html I have a similar problem, but instead of 6 coloums and combinations of 3, I have 20 coloums and want to find...

Hi All, I kindly ask you to help me out on what I'd like to reach. I have a list of numbers (around 100) and I'd like to get all the potential combinations of sums in pairs. To simplify: If I have these three numbers: 1 - 2 - 3, I would like to get the follwing result. 1+1= 2 2+2= 4 3+3= 6...

I have a problem regarding to excel binary combinations. As you see there is a matrix (Matrix 1) with the values of 1 and 0. --- represents N/A or 0. I want to get all different combinations without changing the sums. Matrix 1: <tbody> Sum --- 1 0 1 0 2 1 1 1 1 0 4 1 0 1 --- 0...

Hi, Awhile ago wideboydixon helped me and built a formula to combine all possible combinations without duplicates or reverse order duplicates. Previous thread: https://www.mrexcel.com/forum/excel-questions/989848-combine-all-possible-combinations-single-column-without-vba-2.html#post4750264...

Hello, I'm not familiar with the coding world very much. I have just one main requirement for my project. Detect F10 key release/up and trigger the following two key combinations in the sequence given below. 1) Shift+Home 2) Ctrl+C I really hope it can be done. Thank you and will...

In Worksheet1 I have a small table (AK28:AZ28) of numbers which have been established via a calculated event (example: the formula in AK28 is =IF(OR(AK25="X",AK24=""),99,AK24)). AK24 would either equal a number (1-20 or 99) or an X. The "X" represents the number has already been use, the 99...

Hello everyone, Im trying to extract just the left hour value from the string with the Left function but dont know why it doesnt work. Sometimes there are just 5 positions to substract and sometimes 6. I tried with the following Formula with many combinations...

I have a spreadsheet that allows the user to input different employee/bonus combinations and based on the combination, I have assigned a number 1-4. For instance: A = 1 A+B = 2 A+C = 3 A*B = 4 I created a large nested IF statement to account for every combination, but I have two combinations...

Hello, I need to create a macro that will give me all combinations of the listed data in sets of N. So lets say N is 2 i want 1*2 then 1*3 and and so on. I have seen a lot of looked and have seen macros similar to what i need but cant figure out how to adjust them to work for me. <tbody> A B...

From these eight numbers 7, 6, 6, 5, 4, 4, 3, 2. Using only 5 of the 8 numbers what combinations equal sum of 23 or less?

Hello everyone, need one small help. I have a base date for forecasted sales at customer-product id-month-location level with lot many other fields. For some combinations of product id-customer-location; there are no records since there is no forecast available. I want to create all such...

Hi everyone, I'm working on a categorisation project for work and needed to know how to perform a specific action. I've identified a list of key words from invoice data, the spreadsheet we're working with also contains a general ledger account (GLA) for each invoice. I need to find a way to...

Hi all, I can do some basic VBA and would love to fix this myself, but I just can't (yet) I believe it requires some real Excel wizard master. So here is the thing: I have tracked down a wonderful macro (I think it was originally created by member shg) This macro generates all possible...

I've been handed a data set with 70,000 entries - that were put together by someone lacking vision and understanding. They put in Column A the employees' entire name - in varying forms - and we need to extract it all. in to new cells for first, middle initial/name, last, suffix. Below is...

I am trying to find a solution to this problem. I want to be able to return all of the possible combinations of numbers. A B C D 1 1 1 1 2 2 2 2 3 3 3 3 A + B + C + D return the values of A1B1C1D1,1112,1113,1121,1122,1123, through to 3333

Hi All I need to find a way to list all possible combinations/permutations on excel. I have a list of 8 games of soccer each with a possible outcome of win, draw or win. I need to be able to show every combination for the 8 different results (not including 2 results from the same game). 8...

Hi, I need some vba to check if a cell contains the combination of NUMBER LETTER NUMBER or starts with a Letter However, not sure where to even begin with this... It will be part of a much much larger code, but for a simple example lets say cell A1 is the cell to check and the msgbox says...

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!

Using Excel 2000 Hi, I got table, which got 3 groups of 14 numbers & 14 sets each with 3 numbers Building combinations in the set of 14 numbers it could make with min to max sum, which is in the range of 287 to 315 are listed in the cells U5:V33 3 groups - each group contain 14 numbers...