Hi Community,
Looking for assistance for a code/set of formulas that can be used to generate a list of numbers that all must have a minimum and maximum (randbetween). The sum of the list of numbers also must equal a target.
The solution needs to be efficient / low process and dynamic. The list must be able to auto-generate new sets of numbers (as they will feed into a monte-carlo simulation), with number of cells in list a variable input. I haven't worked much with macro/vba so not sure if once you've got a script whether it can run automatically in the background without needing to be re-run.
I have got a spreadsheet attached with an approach i came across in another forum, which has somewhat improved my previous approach. However as I am now testing the use of this on a larger dataset later numbers in the sequence are being forced to exact values in order to achieve the desired sum target.
Hoping someone may know a fix to this, or an alternative solution.
Appreciate the help - and look forward to seeing if someone out there has a robust solution to this problem.
Thanks,
Chris
Bookmarks