combinations

Hi, I am unsure if this already exists but have spent days looking for what I need and cannot find it. What I am looking for is a VBA that will provide all possible unique combinations within a range. The range will be variable to input - in column A from 1 to 12 entries. Lets say- A1 -...

Windows 10 v1809 Excel 2010 I'm struggling to simply fill a column with consecutive dates for a month, ie Fri 1 Mar 2019, for some reason. I've done this many times before but, today, this just won't work properly. I've checked with Google but the links all same the same thing, ie type date...

Have too many ifs in my formula. If I trying using IFS the formula doesn't work. Tried usings IFS, and several other combinations but to no avail. Maybe I'm trying to do too much for cell...

Hi everyone, I'm looking for help with a solution to generate all possible combinations of a set of data, and have these combinations shown in separate columns. Small example: <tbody> a 1 z & a 1 z & b 2 y a 1 y & c x a 1 x & a 2 z & etc etc etc etc...

Hi all, I am not Excel proficient so sorry if this is a dumb question. I’ve spent over an hour trying to find help on Google. Im trying to create a table with the same data in the column and row headers to show possible combinations and the results that they created. I also need each new...

Hello, I am seeking help on the following problem: <tbody> a b c d f g h i j k l m n o p q 1 Upgrade 1 Upgrade 2 Upgrade 3 # employees Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Jan Feb Mar 3 </tbody> I need to write a formula for cells F2:Q2 that calculate the...

I've seen other threads on this topic but can't find anything to fit my needs. I am seeking a method to list all combinations of numbers 1, 2, 3, 4, 5 & 6. However, I also need all of the combinations of fewer numbers. Examples: 1,3,5 and 2,3,6 and 1,3,4,5,6 However, I don't need repeats...

Hello,</SPAN></SPAN> I have set of 14 numbers in cells A5:A18 I want to have combinations as shown below this probably will make 16384 rows</SPAN></SPAN> Here is example </SPAN></SPAN>...

Hello,</SPAN></SPAN> I got 14 numbers in cells A5:A18 these numbers are changeable every time but (but always will be the 14 numbers)</SPAN></SPAN> I need VBA code, which can generate all possible unique combinations with 6 numbers in the columns D:I and sum of each row combination must be 6...

Hello, In the example below columns C:I in the cells C4:I12 got 9 numbers in each columns the all combination will reach 9^7 = 4,782,969 which minimum sum is 0 and max sum 162 I require a code which can only give me how much combinations could be made with each sum through 0 To 162 and the all...

Conditional combination's pick only "1" number from each column in the row <o:p></o:p> <o:p></o:p> Hello,<o:p></o:p> <o:p></o:p> I have some numbers in column D:J (each column has variable quantity of numbers in it) <o:p></o:p> In the column D only 1 number which is 2 (this is like a joker...

Please help, I need to generate rounds for security guards at multiple stations and I am looking to see if someone can help me using the code below to create a macro that would print only the unique permutations/combinations in sheet 2: For instance in sheet 1 my input would be the guards ID...

Hello, I have 6 columns worth of data (random numbers). How can I get every combination of possibilities? The numbers can be duplicated but once all combinations have been determined, go to next number. I'll out an example. <tbody> 1 23 32 49 53 12 2 50 54 20 29 64 </tbody> So possible...

I have data organized in Sheet1 in range A1:G4 with the first table below; row 1 is a header row. Columns A and B have the lower and upper bounds of a range of Sizes. C:E have Colors and F:G have Shapes Consider the following data in Sheet1: <tbody> A B C D E F G 1 Size Size Color Color...

Hi I have a spreadsheet which works but it is way too slow - what I'm trying to do is to aggregate daily time sheets by person and job, determining the unique combinations of people and jobs then adding the total values for those combinations by week number. I've used concatenate to determine...

the number can be from 7-16 digits and sometimes leads with zero. I cant make it show with the lead zero because the number changes in length. please help novice user. multiple combinations like 9296030230000, 112924100, 050304566, 0956455156220000. I can use as text if needed. Thank you. Sorry...

I have a 4 digit padlock like this one that I have forgotten the number to. I can buy a new lock for ~$15 but I'd rather try & unlock the one I have. I'd like to create an excel sheet that contains all the different possible combinations (10,000 of them). That way, I can keep track of the...

As I understand it, the combin & permut functions only calculate the results without replacement. There are no corresponding functions for with replacement. Is that correct? The formula for permutations with replacement is just n^k, but the one for combinations is ugly: (n+k-1)!/k!(n-1)!. Do I...

Hi, I need a script that takes an InputBox entry separated by commas then form number combinations of two from the data entered. The InputBox will always take a maximum of 5 numbers separated by commas. Example "00,01,02,03,04" And then form all the combination of two : "00-01" "00-02" "00-03"...

Hello, I have single column in Excel with 6 unique values and I want to list all possible unique combinations (combinations of 2, 3, 4, and 5). Example: Column A John Jones Jamy Sarah Mark Mike The output I'm chasing is all possible combinations of 2, 3, 4, and 5. Example: (John, Jones)...