Forum Discussion
need cells combination of cells that will follow 2 conditions rules
Here is a small proposal for a solution ... very simple but clear.
If I can recommend you, add a file (without sensitive data) and explain your plan by adding something to your question in the file.
This means that you can be helped faster and more accurately and it is made easier for the helpers to offer you a tailor-made solution.
Hope I was able to help you and would be happy to know if I could help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Thank for your proposal.
Actually, the transportation truck can take 5 cars at the upper level and the rest 5 at ground level.
Every level has a limit of 19 meters length in car load.
Therefore i need a formula that will identify all 5 car (out of 10) combinations that will have a maximum sum of 1900 (19meters shown in centimeters) in order to fill upper level for example, while at the same time, the rest 5 will also have (as group 2) a maximum sum of 1900 in order to fill ground level.
In my opinion, its pretty clear as a thought, but can't get close to a solution as far as excel programming is concerned.