Generating a list with random units per sale from a list with the totals

Hey guys,

I have the following problem:

There is a list with total units of sales for the different products during the month: e.g.

Product A- 50 units
Product B- 100 units
Product C- 200 units

What I need to do is generate them as a list with single sales with random units per sale. I need to be able to define the range of the units per sale (for example 1 to 4 units for Product A, 2 to 6 units for product B per sale, etc).

So the end result would looks:

Product A - 1 units
Product B- 6 units
Product A- 4 units
Product C- 1 units
........etc. etc.

And in the end, if I sum up the units in the second list, they make up the totals in the first.

I have always been able to find solutions for divers challenges with excel, but for this one, so far I had no luck.

Thank you in advance.

Regards,
Juliana

Hi p24leclerc,


Thank you so much for your help! Sorry for not uploading the sheet. It works perfectly and it is exacly what I needed .


Have a nice day.

Kind regards,
Yuliana