+ Reply to Thread
Results 1 to 5 of 5

Random selection of names with no duplicates and ignoring a predetermined name list

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Random selection of names with no duplicates and ignoring a predetermined name list

    Hi

    I want to generate a random list of 50 names from a population of 300 with no duplicates and I also want the list of 50 to not display any names kept on another sheet

    Are you able to help me?

    Thanks!!

  2. #2
    Forum Contributor
    Join Date
    03-15-2007
    Location
    AL, USA
    MS-Off Ver
    2007
    Posts
    174

    Re: Random selection of names with no duplicates and ignoring a predetermined name list

    Please Login or Register  to view this content.
    Found the funtion online a while back, never thought I'd end up using it.

    After this code runs, you can then use an index formula to get your names.

    It's a start, ignoring names on another list... that's the difficult part.

    You could have your list of 300 reduced by the names to ignore, and then adjust the random number parameters in the macro.
    Last edited by mshale; 07-12-2012 at 10:30 AM.

  3. #3
    Registered User
    Join Date
    07-12-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Random selection of names with no duplicates and ignoring a predetermined name list

    Thanks! I was hoping to not have to manually take out the items i want to ignore but it seems I can't

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,348

    Re: Random selection of names with no duplicates and ignoring a predetermined name list

    Hi iain.excel and welcome to the forum.

    Find an example workbook with what I think is the answer you want. Look at the formulas in Col B.

    You will need to press F9 to get a new set of random numbers and then sort the table by col B (small to large). Take the top 50 names and that is your answer.
    Attached Files Attached Files
    Last edited by MarvinP; 07-16-2012 at 07:53 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Registered User
    Join Date
    07-12-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Random selection of names with no duplicates and ignoring a predetermined name list

    Thats it!! Works a charm!

    Thanks MarvinP!!

+ 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