Five Random Numbers To Get A Given Number

The objective of this video is to generate 5 random numbers that sum up to a certain value. I will be using iterative calculations which is a feature not used much in Excel. Hope this is useful.

[@RuchikaAggarwal-nb1qt]

Hello sir,your session is very informative and helpful but few values remain unchanged.what is the reason for that.

[@shahadotsany]

Thank you very much for your informative tutorial.

[@mahranmd]

انت رائع يا دكتور
ملك الاكسل

[@pranshusoni7461]

What if a column or all the columns have different range but the summation of row is fixed.
In this video all the values are between 1 and 12. Now for example if column A values lie between 11 and 21 (and values for rest of the columns B,C,D&E is between 1 and 12)
How we will maintain the row 1 summation as 31.

[@RamizAssaf-E]

what is important is that there is a way it might happen. Eventually it will reach that value .

[@samsemwal2915]

thank you for the help

[@juniormbua8189]

How can I contact you directly??

[@Rajeshbaldaniya90]

I have a query to generate 40 random numbers to get a predetermined sum that i mention on column
Can you guide?

[@RamizAssaf-E]

sure... sorry just saw it

[@juniormbua8189]

Hello sir good day I would like to learn how to divide from 1 to 59 to get a particular 4 number

[@RamizAssaf-E]

I didn't get it.

[@ClassicBoxing_]

Pls. Give me yung sample