Can this be done in Excel? Using the digits 0,1,2,3,4,5,6,7,8,9 create all the permutations/combinations with limits on some of the digits. The digits 0,7,8,9 can only be used a max of 3 times in any one permutation/combination, digits 2,3,4,5,6 can only be used 4 time in any one permutaion/combination, producing a 5-digit string.
Example of expected results.
0 1 0 2 7
I have found this very challenging, and have really confused my self on how to systematically approach this. I have the user enter the value in the black highlight boxes, some subtraction produces a base value, the user may also enter the tolerance of the working value (base value), effectivlly giving rise to a small range to generate the permutations from.
What I would like to do then is find all permutations of the inventory (letters in the sheet) with their corresponding values right above them to the small range determined via the user (working value and tolerance). There are also quantity limits for each item. There four basic rules that need to be adhered to:
1) Permutation can't have both S and PP, so one or the other 2) Sum of H and HN must be greater or equal to sum of S and PP 3) H or HN or both must be present, so their sum cannot be zero 4) If HN is less than or equal to 2, and H is greater than 2, then NA and NG must equal 0.
This is for an online sports management game I play. Basically I have calculated each players skills in each position, and I need to find the best combination of the players on the field to give me the best team.
I have a table as below, and I need to find a solution that gives me what the best combination will be....
I am trying to create a list of permutations in a column for example I need a list of numbers 1-20 with no numbers repeating. This is causing my head to hurt and I have been working on this problem for some time.
I have been asked if I can create a pseudo Lottery/Bingo card of 7 images with no repeat cards. The best i can tell is that I need to create a Permutation of the numbers 1 - 7. There should be 5040 combinations of unique possible cards. My problem being I don't know how to create this Permutation in Excel.
i have read through all threads about permutation, and also a few others. I if I were an Excel Pro I would probably have been able to come up with a solution to my problem based on all the suggestions made, but unfortunately it is (still) all a bit too complex for me.
I have between 2 and 5 lists of words, each list in one column:
red green yellow black blue green pink
shirt jumper blouse coat t-shirt skirt
for women for men for girls extra large for boys one size fits all
I have several items that I would like to combine, lets call them characters A, B, C, D, E
Each character is situated in a different column, next to each other. Below, I would like to create a list of all possible combinations of these characters. The sequence is not important and each row should contain a unique combination of characters.
I have counted 31 combinations for the ABCDE set, namely
1 for ABCDE 5 for A, B, C, D, E each 5 for choosing 5 unique sets of four from a set of five (5!/(4!*(5-4)!) 10 for choosing 10 unique sets of three from a set of five (5!/(3!*(5-3)!) 10 for choosing 10 unique sets of two from a set of five (5!/(2!*(5-2)!)
To complicate matters, I have several other character strings where I would like a list of combinations. For example A, B, C, D, E, F, G, H 9 (a longer set).
By the way, each combination should be spread accross several columns (e.g. one colum per character, see the question marks in the table below) ....
I'm new here, google helped me to find this place. Hope someone here can help me a bit on my excel spreadsheet. I have one list of numbers and it need to be sorted under Perm condition so the list become shorter. The function should go through the listed number and output new list after sorting it. I have attached my excel here.
I have a column of transactions lets say 500 or so, of irregular numbers such as 257,273.80 (not something ou can add up in your head...). I know that of those 500 transactions a handful of them have a sum of lets say 2,877,000.00, which I know. Now I need to find all possible combinations of values in this column that equal a sum I enter.
I've attached an Excel..Its a small 4X4 matrix with numbers filled inside...Next to the right is a Combinations Column..I want to know how can i use just forumla to optain 4digit combination based on the 4X4 matrix. Rule is only numbers from the 4X4 be used.
I have up to 30 cells each with an integral value from 1 to 5. The task is to list all the ways that selections of from 1 to 5 cells can be made from the list such that the value of the sum of the selection is 5. It will usually be the case that there will be a final selection that will not sum to 5 and this needs listing also.
I am aware of coding that can list out combinations, but not in a form that can be adapted to deal with the summing limitation. I hope that I will be able to code so that I can deal with different numbers of cells and different sum values.
I have a table with 3 columns and n number of rows looking like this: A1 A2 A3 B1 B2 B3 C1 C2 C3 D1 D2 D3 ...
I need to create a macro that gives all the sum combinations like this: A1+B1+C1+D1 A1+B1+C1+D2 A1+B1+C1+D3 A1+B1+C2+D1 A1+B1+C2+D2 A1+B1+C2+D3 A1+B1+C3+D1 A1+B1+C3+D2 A1+B1+C3+D3 A1+B2+C1+D1 A1+B2+C1+D2 A1+B2+C1+D3 ...
I have a simple list of names with associated numerical values.
I would like to create a formula that will produce a series of all possible series of 8 of those names whose combined numerical values are at or below a certain threshold (or between two thresholds, if that's easy). Bonus points if the total combined value for each group is easily shown, but that'd just be gravy.
I want to see how much combinations are possible when i got 6 numbers..
-- got this numbers 1--2--3--4--5--6 -- want to calculate how much combinations of ( 2 ) numbers possible -- want to calculate how much of ( 3 ) numbers possible -- want to calculate how much of ( 4 ) numbers possible -- want to calculate how much of ( 5) numbers possible
-- never 2 same numbers together (2-2) or (2-2-3) or (2-2-3-4) may not be in list
-- How can i make the result visible in kind of list ?
I would be nice if somebody knows a good solution..
i'm doing a process and in column N, i would need to have the following combinations:
A1 A2 C1 C2 H1 I1
so basically, a formula that would figure out the combinations available! can this be done using a formula?
I have a list of numbers from 1 to 20 form a2 to a21, what I would like to do if possible if figure out many combinations of 5 there are for these numbers, and then second if possible display the combinations.
E.g. say there was a total 250000 combinations then show those 250000
I want to have a sheet with all the previous drawings for the florida lottery. Then I want excel to ask me how many numbers do I wish to play.
Then when I say 12 (for example) it would pick 12 numbers from 1 to 53 and match all possible comibinations of thoses numbers to the the previous drawings and tell me wich 12 number combination would have won more times then others. So it would need to compare each possible 12 nmber combination to each other and see wich one won more 6outof6, 5outof5, 4outof4, and 3outof3. Then give me the one with the highest winings
I have a table: VOICEDATAIPADSLCustomer 1YESCustomer 2YESYESCustomer 3YESYESCustomer 4YESYES
And i need to count all possible combinatins. Result could be as:
Custome who use Voice also use combination:1VOICE ADSLCustome who use Data also use combination:1DATAIP2DATAADSLCustome who use IP also use combination:1IPDATACustome who use ADSL also use combination:1ADSLDATA
Now there is the number and the number(A) that it value it represents (B). This is what I want. I want to see all possible number combinations between the upper and lower A columns listed veritcally under the whole set, with out duplicating any numbers and with the upper numbers only being in the 1st position and the lower numbers being in the second position Ex( 4-1, 4-8, 4-2, 7-4, 7-1, ect, ect (listed vertically). Now in column B under, right beside each possible combination I want to see the result of the two values multiplied (ex. beside 4-1 I would like to see 0.1)
So below that mess listed above I want to see something like this
A B 4-1 0.1 4-8 0.0125 ect ect ect
I want to be able to swith the values around and have it automatically make the correction.
I am trying to create a combination list. I have 48 items and I want to create all possible comibinations of 3 items from this group of 48 items.
I did something similar to create all possible combinations of 2 items from the group of 48 items in the attached spreadsheet. This was done manually and was time consumning. I want to do something similar for all possible combinations of 3 items from this group of 48 items.
All my 48 items are listed in rows 4 and 5. I want to enter the number "1" in each column to indicate my selection. Right now I have 2 ones per row. But I want to do 3 ones per row.
I need to find the possible combinations for several arrays consisting of binary data. I shall give a simplified example with three arrays and four fields. Lets assume the three starting arrays look as follows:
1 0 0 0 1 0 0 0 1 0 0 0
Each row may contain one field = "1" and all other fields = "0". So the next possible combinations may be:
1 0 0 0 1 0 0 0 0 1 0 0
1 0 0 0 1 0 0 0 0 0 1 0
0 0 0 1 0 0 0 1 0 0 0 1
Assuming k = number of fields and c = number of arrays the possible combinations are k ^ c = 4 ^ 3 = 64. I am looking for vba coding that allows to cycle through all possible combinations and displays them in an excel spreadsheet. Ideally, the code should work for any k and c. Could anyone please give me any pointers as to how to tackle this problem?
p.s. in essence I'm looking for the tabular representation of a tree plan with four branches to commence with, a total of 16 decision nodes, and two possible outcomes (1 and 0)
Outside the door of my flat I have a key holder – which has a combination of 4 digits. No-one knows what the combination is, so I’d like to try to find it, clear it and use it. I wondered if there was a way to use excel to show all of the possible combinations so I can then tick them off as I try them…?
The possible numbers are 0-9, but you cant press a button more than once in any given attempt… so… first possible combination would be 0123… not 0001.
This supposed to block Alt key and all combinations with it except Alt+F1, Alt+Tab and Alt+Shift. But what I get is: if I press Alt+F1 only, F1 is triggered.
Private Function LowLevelKeyboardProc(ByVal nCode As Long, _ ByVal wParam As Long, _ ByVal lParam As Long) As Long
Static kbdllhs As KBDLLHOOKSTRUCT
If nCode = HC_ACTION Then Call CopyMemory(kbdllhs, ByVal lParam, Len(kbdllhs)) If CBool(kbdllhs.flags And LLKHF_ALTDOWN) Then Select Case kbdllhs.vkCode Case vbKeyF1, VK_LSHIFT, VK_TAB Case Else LowLevelKeyboardProc = 1 Exit Function End Select End If End If LowLevelKeyboardProc = CallNextHookEx(m_hDllKbdHook, nCode, wParam, lParam) End Function