combinatorics

I need a formula to make 2D array of combination of a number of elements given an array of possible variables. Below is the sample input output: ne = 2 x = {a;b;c} out = {a,a; a,b; a,c; b,a; b,b; b,c; c,a; c,b;, c,c} ne is number of elements as integer, x is list of variables as 1d array of any...

Hi. Suppose I have a column range of 10 cells. I would like to get 8 of them uniquely and randomly. How do I do that (without macro)? Thanks.

Hi guys! I've looked for a way to do this in several foruns and website and found no clue... Hope someone can help me! :biggrin: Here is a sample of the data I have: <tbody> Student1 Student2 Student3 Student4 Nascimento MS Espindola CF do Prado C Bhansali S Nascimento MS Dhawan V...

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

Dear community, good morning. I am new to this forum and hope you can help me. Here is my problem. Short version: 1. I need VBA to generate all possible combinations following a certain logic 2. Once a new combination is found, this combination needs to be evaluated with a certain function...