Forum Discussion
multiple outcomes of randomized dataset
mathetes Thank you so much for the quick response! I created a simplified worksheet to give more insight in the problem. In the sheet the data point I like to work with is marked yellow. It depends on the data above it, which are random numbers, so every time it is re calculated, the yellow cell gets a different value. I would like to get the first 100 (recalculated) values of the yellow cell.
And it would seem to me that just making multiple copies of that column, as I've done here, accomplishes the desired result. I didn't do 100 copies, but you get the idea I'm sure.
mathetes Hmm yeah, unfortunately that is not possible for my real data set since that one is a little more complicated. But I'll find a way, thank you very much for your help!
Well, my very first sentence on my very first response did say that it would depend on how your data are arrayed. I guess that's the issue. It sounds like a macro might be in order (unless a rearrangement of the data is possible). I'm not a macro person; sorry.