Hey, I am trying to find the different combinations that can be formed by choosing 11 out of 22 objects ( i.e. C(22,11) ). I have posted below the code I tried using. the problem is that this code give me all possible combinations whereas I only need different ways in which 11 objects can be...
Hi,
I have a set of unique items that I have to assign to specified locations. The number of locations is determined by the sum of the items' values, rounded up to the closest integer. See for an example below:
Item
Value
A
0,11
B
0,22
C
0,44
D
0,44
E
0,67
F
0,33
G
0,25
H
0,5...
Hello,
I have a combination stack columns with line chart. The stacked columns being hours worked and the line being hours available to work. The data sets being stacked are hours worked per discipline. The problem is one data sat is not stacking on top of the other data sets. It's gone rogue...
Hello Everyone
i want to make all possible combination lets say of 5 digits for 5 numbers ( 1,2,3,4,5 )
11111,11112,11113
but i want to exclude certain outputs by limiting repetition of each char to 2 in a row
like 11234 is acceptable but 11123 is not , as ( 1 ) is repeated 3 times
can this...
Hello,
I am trying to creating possible combination for five columns and I am using below formula which is for 3 columns only, I am trying add 2 more columns but its not letting me or formula is not right...
0
i have 10 cars that need to fit in a car transporter truck. I have a limit on the length of the truck, which can take 5 cars in upper level and the rest 5 in ground level. i need a formula that will take the 10 car lengths and give me all possible 5 car combinations that dont exceed the truck...
Hello Excel Users,
I have a spreadsheet with multiple tabs where the first tab has unique numbers and the other tabs has the the unique numbers with multiple values associated to it. I need to have the first tab return the multiple values from the second tab. Column B in the first tab is what i...
I have a number of vectors A,B,C,...etc as a pair of numbers such as below:
x
y
1
A
2
4
2
B
5
6
3
C
3
9
I want to list or at least find the combination that produces the minimum x^2 + y^2, by taking combinations by 2 or 3 vectors. I've tried solver unsuccessfully...
Hello!
I'm trying to find what possible combination of numbers is causing a variance. I saw someone do a formula once to find this but I don't have that formula. We have a statement with close to 500 lines and I wanted to be able to find which combination of those number would make $$$ amount...
Hi,
I'm having an issue with making a macro that creates a new worksheet for every unique combination of 2 columns
(Category and procedure). All the worksheet will then have a "form" with all the columns related to that combination.
Is there anybody that can help me?
Thank you.
Thanks in advance
in column "A", i have the numbers, suppose it is 0 to 99
(1) Now i want the list of generated numbers through combination with no repeats in the set of 5, please provide any vba code
(2) I want the list of generated numbers through permutation with no repeats in the set of...
I have a target sum to achieve with some constrains such as - individual numbers have a constant divisor, variable must be of 2 decimals only and sum target for 2 out of 5 data.
The grand total of the row totals must be 62,185.
I tried to use solver, but got stuck.
<tbody>
Divisor
Hours
Row...
If I have a date in Cell A1 and I want to get the start date of the next week, how is that possible?
So: A1 shows 7/26/2019.
I want B1 to display 7/29/2019 (week begins on Monday).
I know it is some combination of WEEK and DAY but not sure how to do it.
I need a combination formula for If error and if result of formula =0. Formula I have now for if error is the following:
=IFERROR((I2-J2)/J2,1) however if cell I2=0 and J2 =0, I would like the result to be 0.
Thanks for your assistance. I know this has to be something simple.
Hello!
I'm working on a code and have come upon something that I hope has an easy way to do.
In it, there are 3 cells in the workbook. Each cell can only have 1 of 3 possible string values in it. For this example say A, B or C. Depending on the combination of letter, they receive a different...
Here is the formula I used which contains combination of IF and INDEX
=IF(STREAM!E5:E54>0,INDEX(STREAM!F5:F54,P1,1),INDEX(STREAM!E5:E54,P1,1))
In this, I have faced the problem that only one condition returns output, other returns 0.
If STREAM!E5:E54 is true then it returns the value of...
Thanks in advance
I want to know that from the given
(Query-1) numbers 0,1,2,3,4,5,6,7
(Query-2) numbers 1,2,3,4,5,6,7,8
how many combination we can generate without repetition and if possible pls provide the generated combination.
Hi, how would i go about creating worksheets for every possible combination of data. but the data is in the same row, only separated by by one blank row... there are significantly more then shown below..
x1
x2
x3
y1
y2
the tabs (new worksheet) should be created is
x1-y1
x2-y1
x3-y1
x1-y2...
Hi All,
Based on another thread I had posted on Jun 1st, 2019, 08:04 AM I would like to create a macro for a variation of the original design I had created. A successful macro created and provided by member DanteAmor satisfied the original design requirements as per below:
____ORIGINAL...
Hi All,
I've moved around my "if" and "end if", as well as the "for" and "next" statements in my code, but I continue to get one of those two...
We've detected that you are using an adblocker.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.