# Record Repeats of random function

1. ## Record Repeats of random function

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

2. ## Re: Record Repeats of random function

Why not just put the formula in A1:A1000 and use the FREQUENCY function?

3. ## Re: Record Repeats of random function

Problem is, that I have just used a simple example to illustrate the issue. Actual problem is about exchange rates, numbers have 7 decimal places, and there are many more than just one.

4. ## Re: Record Repeats of random function

Problem is, I can only respond to the questions you ask ...

5. ## Re: Record Repeats of random function

Fair enough,
Here is attached question.
How do I make Excel record calculation repeats (the ones Excel does when F9 is pressed), of the column 'possible rate'?
I.e. make excel repeat calculations 1000 times and export result to the chart for each currency.

Thank you

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1