+ Reply to Thread
Results 1 to 2 of 2

Generating a Random Number of Random Numbers

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Generating a Random Number of Random Numbers

    I assume macros may be the best way to tackle this problem but I don't have much experience writing code. Essentially I would like to generate one random number (say from 1-10), then generate that number of random numbers. For example, if a 3 is the initial number generated, then I would like to generate 3 random numbers somewhere else on the worksheet.

    I suppose I could accomplish this using a lot of IF statements, but that seems like a messy solution. I may also run into problems later on if I run a number of trials, each dependent on the results of the last trial. Any help is greatly appreciated.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    MS-Off Ver
    365 ProPlus

    Re: Generating a Random Number of Random Numbers

    Something like this:
    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)


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