Results 1 to 4 of 4

Generating random cells from a list

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    Port-Louis, Mauritius
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Generating random cells from a list

    Hi, I'm a newbie to VBA

    I have a list of participants who've each had 0 to 5 attempts at an event and a list of scores obtained.
    Suppose a participant has had 2 attempts, I have to randomly choose 2 scores from the list given.
    If one has had 3 attempts, I have to randomly choose 3 scores and so on.

    How do I proceed ? Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generating Random String from Text in Cells
    By abbeycrombie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-18-2013, 12:09 PM
  2. Generating a list of Random numbers of random length...
    By Growl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 12:10 PM
  3. Generating a list of reports as HTML in a .txt file depending on cells
    By john_london in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2012, 06:01 AM
  4. Generating a Random Number of Random Numbers
    By Garrus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2010, 09:39 AM
  5. generating random number list?
    By planetizzie in forum Excel General
    Replies: 10
    Last Post: 10-21-2009, 11:45 AM
  6. Randomly placing 5 same alphabet in a range of 20 cells. (Random Generating)
    By Excript in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2009, 09:52 PM
  7. generating a whole random # from a list
    By Arturo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2005, 07:05 PM

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