milindighe
New Member
- Joined
- Jun 2, 2020
- Messages
- 2
- Office Version
- 2019
- 2016
- Platform
- Windows
I have, Total no. of Boxes, Total no. of items that goes in boxes and each box can have Min and Max count.
For Example,
If Total Boxes = 80, Total No. of Items = 240, and each box can have Minimum 5 and Maximum 10 Items.
So, I have to generate a table of 80 boxes, where 240 items are distributed. And each box can have Min 5 and Max 10 items.
How to generate such table with random items between 5 to 10 among 80 boxes whose total is 240?
For Example,
If Total Boxes = 80, Total No. of Items = 240, and each box can have Minimum 5 and Maximum 10 Items.
So, I have to generate a table of 80 boxes, where 240 items are distributed. And each box can have Min 5 and Max 10 items.
How to generate such table with random items between 5 to 10 among 80 boxes whose total is 240?