Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard to do? randomly
The number i put in cell A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible? Farmer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard to do? randomly
Very easy:
In B1 thru B30 enter: =RAND() In B31 enter: =SUM(B1:B30) In A31 put your value In A1 enter: =$A$31*B1/$B$31 and copy down thru A30 A1 thru A30 will consist of random values which sum to the value in A 31. -- Gary''s Student - gsnu2007g "farmer" wrote: The number i put in cell A31 must be ditributed randomly from cell A1 to A30 so the summary of A1 to A30 must be like A31. Is this possible? Farmer |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard to do? randomly
Thanks alot , you people are great.
Farmer "Gary''s Student" wrote in message ... Very easy: In B1 thru B30 enter: =RAND() In B31 enter: =SUM(B1:B30) In A31 put your value In A1 enter: =$A$31*B1/$B$31 and copy down thru A30 A1 thru A30 will consist of random values which sum to the value in A 31. -- Gary''s Student - gsnu2007g "farmer" wrote: The number i put in cell A31 must be ditributed randomly from cell A1 to A30 so the summary of A1 to A30 must be like A31. Is this possible? Farmer |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard to do? randomly
Hello,
That's one possible solution. The distribution will almost look like the green curve shown at: http://www.sulprobil.com/html/randsum1.html The maximum (meaning the most likely values) will be at A31/30. If you like to test other possible distributions as well: Select A1:A30 and array-enter =A31*randsum1(1) or =A31*randsum1(3) Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
randomly fill | Excel Worksheet Functions | |||
randomly selection | Excel Discussion (Misc queries) | |||
This is a hard one... | Excel Discussion (Misc queries) | |||
Randomly choosing | Excel Worksheet Functions | |||
Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) |