mercredi 29 novembre 2017

Randomly generate x whole numbers with sum of y with Excel

I was referring to this post on generating random x numbers using =RAND(), however it cater for every number including those with decimal. I want to generate only positive whole number (e.g. 1, 3, 50) and not those with decimal.

To be clear, for example, I want to generate:

50 random positive whole numbers that has the sum of 1000

PS: If you find this question for Excel solution redundant, let me know and I'll close this.




Aucun commentaire:

Enregistrer un commentaire