Results 1 to 2 of 2

Generate random list with no duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    Deskford, Buckie, Scotland
    MS-Off Ver
    2010
    Posts
    1

    Generate random list with no duplicates

    Hi,

    I new to this and therefore somewhat lacking in know-how, basically I have a spreadsheet which has Random numbers between 1-125 with no duplicates in column A =LARGE(ROW($1:$125)*NOT(COUNTIF($A$1:A1, ROW($1:$125))), RANDBETWEEN(1,126-ROW(A1)))

    I then have a list of 125 songs in column B

    I want to randomly select 16 out of the 125 songs for a bingo style game (i need to be able to randomly select 16 songs over & over again for Bingo Cards)

    so in column C, I select 16 random numbers (from the range 1-125) =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1

    what I then want is for the corresponding songs to appear in column D, For example: I shuffle my 125 numbers in column A using F9, This gives each song in column B a completely random number. I then randomly select 16 of the possible 125 numbers in column C, I then want column D cell 1 to look at the numbers in column C cell 1 and match it with whichever cell on column A has the same number (eg: A52) then copy the corresponding song (which would therefore be adjacent to the cell containing the relevant number) and then place that song into a list of 16 songs in column D) Then repeat this over & over generating a random short list of 16 songs out of the 125 each time.?????

    Now I just need to know how on earth I do this? Help greatly appreciated.
    Last edited by zbor; 09-25-2015 at 06:47 AM. Reason: title editer per OP request

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Suggestion-Thread Unread Notification For Editing/Change In Thread Title
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 5
    Last Post: 01-15-2014, 01:54 AM
  2. Equation that depends on table (not sure how to explain this in a title)
    By adwhitle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2013, 10:15 AM
  3. "Explain this" thread title discussion
    By royUK in forum The Water Cooler
    Replies: 34
    Last Post: 08-29-2012, 02:40 PM
  4. No idea how to title this, some sort of referencing
    By redking in forum Excel General
    Replies: 5
    Last Post: 06-15-2012, 09:48 PM
  5. Replies: 4
    Last Post: 05-01-2012, 01:35 PM
  6. This is too difficult to explain within the Title
    By aposatsk in forum Excel General
    Replies: 3
    Last Post: 07-27-2006, 12:59 AM
  7. I Have No Idea How To Do Or Title This!
    By Maxemily in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-29-2006, 11:40 PM
  8. Need help (not sure how to explain in title)
    By Plasma in forum Excel General
    Replies: 3
    Last Post: 10-12-2005, 12: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