hi there,
I'm looking for VBA expert to design a spreadsheet where it can find all combination of a targeted sum. The VBA code should be able to calculate over 8 millions combinations and repetition not allowed, plus showing the quartile for each possible combinations.
Other computer language is also computed.
Example:
Targeted Sum is 52 weeks
combinations: 10,10,10,10,10,9,9,9,9,9,8,8,8,8,8,8,7,7,7,7,7,7,7,6,6,6,6,6,6,6,6,5,5,5,5,5,5,5,5,5,5,4,4,4,4,4,4,4,4,4,4,4,4,4,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1.
Thanks,
David