+ Reply to Thread
Results 1 to 6 of 6

Draw random names from list and then remove, carry on till no names left in list

  1. #1
    Forum Contributor
    Join Date
    04-17-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    122

    Question Draw random names from list and then remove, carry on till no names left in list

    So just to start I have looked online and I can see lots of examples but I just cant seem to get what I want to work.

    Hopefully it is easy, what I want to do is draw a random name from a list in column A, I would like the first name to go into b1 then draw another random name and add that to cell c1, third in b2 fourth in c2 so on and so forth, Every time a name is drawn I want it removed from the original list so it cant be drawn again, I want this to happen until there are no names left in the original list in column A.

    Appreciate any help

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Draw random names from list and then remove, carry on till no names left in list

    If I'm understanding what you want, this might work for you...
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    04-17-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    122

    Re: Draw random names from list and then remove, carry on till no names left in list

    That Is exactly what I require, Just one other thing and as as an after thought could a delay be added between each time some one is drawn?

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Draw random names from list and then remove, carry on till no names left in list

    sure....
    just insert this in the loop....this will wait for 10 seconds...or change it for however long you want....

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-17-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    122

    Re: Draw random names from list and then remove, carry on till no names left in list

    Again right on the money, thanks for your assistance

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Draw random names from list and then remove, carry on till no names left in list

    Glad I could help....that was actually pretty fun and a little different....

    Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-22-2013, 05:06 PM
  2. random pick names from a list
    By jladika in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2011, 05:31 PM
  3. Random list of names in table
    By kazie in forum Excel General
    Replies: 4
    Last Post: 04-18-2010, 10:14 AM
  4. Getting a Random list of names
    By Vijaybidappa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2005, 05:28 PM
  5. [SOLVED] Setting up a random list from long list of names ?
    By yorkshire exile in forum Excel General
    Replies: 4
    Last Post: 01-06-2005, 10:06 AM

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