Good Afternoon everyone.
Again, sorry if the problem has been solved before, but being a new user I couldn't find a solution.
Problem I faced is simple:
I want Excel to record repeats of a random function. Simple example:
I have a function =RANDBETWEEN(1;100) in cell A1 (as an example)
Each time I change something in the table, or press F9, value of the cell changes.
How do I make Excel repeat that function (F9), say 1000 times, and record the result of those repeats (in order to have distribution of these results later on)
Thank you,
Michael
Bookmarks