How do I generate 10 unique random numbers between 1 and 100 that sum up to 100?
Example:
11
23
3
5
18
6
7
8
9
10
–––––––––
100
––––––––––
Had a break and come back to it, think this fills the criteria.
Enjoyed the challenge.
bit messy and could do with going into macro, but ticks all the boxes I think
This is a great challenge.
Let me see how this can be solved.
Hi @gnans19
This is what I came up with:
basically it calls and number between 0-100 and then sums up and takes the % of the total to give a split between 0 - 100.
Let me know if this works.
I hope this helps !!
Thanks
Nitin
Hi @paulfound and @nitinsnow ,
Great solutions. I did a couple of runs.
It seems like it isnt giving unique numbers each time. And is there a way to make it that it doesnt give me 0 as a number.
Cheers and Happy Analyzing : )
Hi @gnans19 @atcodedog05
The workflow generates random numbers at each run (with the addition of 100), and now the numbers are always greater than 0.
I hope this helps, if yes, please accept it as a solution.
Hi @nitinsnow ,
As per the requirement. The number needs to be unique. Its still not unique.
Thank you @paulfound This is amazing. I thought this is an optimization problem and needs LP solution.
