| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to make many random test outcomes in one chart?
For Example, From column A1 to A20 I assign 20 random numbers (A1=rand(), A2=rand(), ... A20=rand()). Then I put B1=sum(A1,A2,...,A20) Every time I press "F9", I got a outcome of B1 Now I want to get the outcome 1000 times, and assign the data to other columns such as C11 to C10000. How to do that? -- vegas ------------------------------------------------------------------------ vegas's Profile: http://www.excelforum.com/member.php...o&userid=25091 View this thread: http://www.excelforum.com/showthread...hreadid=386025 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pie-in-Pie (sort of) how can I make this chart? | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
Threaded Mode
