+ Reply to Thread
Results 1 to 5 of 5

Record Repeats of random function

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    38

    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. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,659

    Re: Record Repeats of random function

    Why not just put the formula in A1:A1000 and use the FREQUENCY function?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-07-2011
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    38

    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. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,659

    Re: Record Repeats of random function

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

  5. #5
    Registered User
    Join Date
    09-07-2011
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    38

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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