combinations

From a list I would like to generate combinations of n members from a set of x possibilities in Power Query. I have found some useful code here on creating combinations of members based on all possible values of n, and here on generating permutations for x, but I regret that I'm not good enough...

for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. Lottery Basics: 7 numbers from 31. Order does not matter. 03 05 08 09 19 21 30 08 11 12 14 20 21 28 11 12 21 24 25 28 29 06 07 13 15 18 19 29 02...

Hi guys, grils, I have 6 columns in excel and every column has like 2 to 6 values. I want to make all possible combinations, but not merged into 1 cell, but with still the 6 columns. I need to import all possible combinations into a database for a webshop, so I need to contain these columns.

Hi all, I have a column of data (10 cells) and I need to do the following: I want different combinations of cells in each following column take a value of "0". So in the first 10 columns - every different cell takes "0" value, then in the following columns there must be already 2 cells with "0"...

Hi everyone, I currently write my Master thesis in the field of renewable energy. I want to implement the famous mean-variance analysis by Markowitz to show how all possible combinations of 10 wind parks are different in terms of return/risk ratio. There must be 2 specific formulas...

We have over 100 accounts that need daily reconciliation. This task is very time consuming. I've used index and match, however, most of our reconciliations involve using combinations of values to match to a value or another combination of values in another column. Is there a formula that can...

Hi I need to create a column with groups so the first variable is from 0 to 14 the next is from 0 to 14 and the last is 0 to 21 i need an easy way for excel to write all the different combinations down e.g 0-0-0 1-0-0 2-0-0 and so on or else i need to write them all down please help

Hello, I need a formula which produces a list of all possible combinations of 4 numbers using a group of 5 numbers without repetition . For example: If the group were 1 2 3 4 5 I would need to produce a list like this: 1-2-3-4 1-2-4-5 Etc My knowledge of excel is relatively basic, so any help...

I have 36k records of various free form text strings in one column. Is it possible to do a COUNT on the number of combinations? If some words are misspelt is there a way to do a fuzzy logic search and COUNT?

<tbody> A B C 1 2 TEAM 1 TEAM 1 TEAM 2 3 TEAM 2 TEAM 1 TEAM 3 4 TEAM 3 TEAM 1 TEAM 4 5 TEAM 4 TEAM 2 TEAM 3 6 TEAM 2 TEAM 4 7 TEAM 3 TEAM 4 8 </tbody> Hy all, i have in column A, (starting in A2) the above: I now need all the combinations of games ( just 1 round)...

So since all pick 3 and pick 4 numbers have different combinations possible, I want excel to highlight them based on how many times each combination repeats. I want to do this for 3 and 4 digit sets separately. Ultimately I want to paste all winning numbers in column A in let's say every March...

Hi, I want to list down all the possible combinations of size 'r' from a list of size 'n'. So let's say I have the following list from cell A1 to cell A6. A B C D E F I want to list down combinations of size 4 starting in column C. So cell C1 to C4 will be: A B C D Then cells D1 to D4 will...

I have a Excel spreadsheet that consists of 6 worksheets. I include the following simply to provide a little background in preparation of asking a couple questions. The worksheets are as follows: Tennis Roster - max 20 players Schedule - For Tennis Doubles (i.e., 4 people needed to make up...

Hi all, I'm playing around with VBA to find different ways of combination generation. I have been able to create a tool to generate all possible combinations of FIVE values from one column Order is not important No repetition allowed Input: <tbody> A B 1 2 3 Variable 4 C 5...

Hi, can anyone please recommend any good Charts for displaying the frequency of combinations ? So for example if I had 10products, that's 1e+10 combinations, is there some sort of heat map chart or area chart that would display the number of the combinations ? Thanks in advance for your help...

Hello, I have a quite large dataset 72501 rows and 36 columns. An example is as follows: 10268|32999226|15351|10272|7662755||||||||||||||||||||||||||||||| 32999226||||||||||||||||||||||||||||||||||| 15351||||||||||||||||||||||||||||||||||| 10272|||||||||||||||||||||||||||||||||||...

Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge

Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge

I can't currently figure out how to do what I want.. Here is the issue. I have a data set with quite a few lines. There are essentially two aspects to the data. One is the location, the second is the item. Each location has a row for however many items it carries. So if location 1 carries...

Hey all, I'm in charge of a syndicate group and we're looking for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. Lottery Basics: 6 numbers from 45. Order does not matter. Can play 7 to 20...