I want to run a bunch of trials with random numbers. Each trial will have a
single numerical result (in a single cell). I'd like to be able copy the
result value (or use an equality equation) of a trial into a cell somewhere
else, and then run the trial again (new random numbers), and then have the
new result pasted into the NEXT cell below (or next to) the first, and so on,
lots of times, so that I end up with lots of results from my trials. Is
there a way to basically have Excel automatically increment the cell row or
column (I don't care which -- I can grab the data wherever it is) each time I
run a new trial? Sounds a little complicated, but the idea is pretty simple.
I don't want to have to manually copy and paste the "value" of the result
each time -- I'd like to run hundreds or thousands of trials.
--
Thanks.
Warren