Hello everyone.
Does anyone know a set of formulas or Macro which would allow me to do the following?
What I have now is a table in which every row has, for each column, a finite interval of numbers that can be chosen from (like: 1, 5.3, 6.7 BUT NOT 5.4, 6.9....). Keep in mind that these intervals change at each column.
The last column SUMS all the numbers from that row.
Now, my question is:
Is there a way to put a fixed sum at the end of each row and make Excel to randomize the value in each column for that row to give me that final SUM, at the same time not choosing any number outside of the boundaries set for each column?
Thank you in advance!
Codetti
Does anyone know a set of formulas or Macro which would allow me to do the following?
What I have now is a table in which every row has, for each column, a finite interval of numbers that can be chosen from (like: 1, 5.3, 6.7 BUT NOT 5.4, 6.9....). Keep in mind that these intervals change at each column.
The last column SUMS all the numbers from that row.
Now, my question is:
Is there a way to put a fixed sum at the end of each row and make Excel to randomize the value in each column for that row to give me that final SUM, at the same time not choosing any number outside of the boundaries set for each column?
Thank you in advance!
Codetti
