Download and free trial Now. Can the vba be linked to a cell that be can changed to to alter the number of balls baskets and maximum capacity per basket. If you are confused with above method Excel contains a Solver Add-in feature by using this add-in you can also identify the numbers which total amount equals a given value.
For example there are 50 balls and 10 baskets each basket can hold a maximum of 7 balls.
For example there are 50 balls and 10 baskets each basket can hold a maximum of 7 balls. Steps Excel 2016 Click a cell in the State table then click the Data ribbon tab click the From table icon This opens the Power Query window. Then in the List All Combinations dialog select Value from Type drop down list click Browse button to select first. Finally A few points to note on the COMBIN Function.