Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person
Results 1 to 5 of 5

Thread: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    So I am looking to pick 250 unique winners for a contest.

    The contest will have 10k-20k unique users. Each user is able to enter multiple times.

    How do i Pick 10 unique users for 1 prize
    How do i Pick 240 unqiue users for 2nd prize

    If your name was picked for any of these prizes it needs to be removed from the list.

    Example:


    ID Name Entries
    1030568867 a1 64 Top Prize Winners 2nd Prize Winners
    1014727335 a2 58 1 1
    1015596467 a3 57 2 2
    1017253571 a4 56 3 3
    1020105929 a5 55 4 4
    1022773019 a6 55 5 5
    1001899839 a7 52 6 6
    1009823660 a8 51 7 7
    1022910204 a9 50 8 8
    1026919113 a10 50 9 9
    1023942346 a11 49 10 10
    1000818364 a12 48 11
    1012926878 a13 48 12
    1015393840 a14 47 13
    1001047502 a15 47 14
    1033266645 a16 47 15
    1011604625 a17 47 16
    1006711599 a18 47 17
    1031942764 a19 47 18
    1003411111 a20 46 19
    1016905165 a21 46 20
    1019830401 a22 46 21
    1022084365 a23 45 22
    1001108980 a24 45 23
    1017275644 a25 45 24
    1002531691 a26 45 25
    1012958629 a27 45 26
    1027693853 a28 44 27
    1028491801 a29 44 28
    1025480181 a30 43 29
    1016018379 a31 43 30
    1025575848 a32 43 31
    1004758705 a33 43 32
    1028821421 a34 42 33

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,149
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    Surely you must give some rules on how to pick the unique winners?

    How is it done? for example where i'm from, some little bits of paper each with an ID on them are put in a bucket and someone puts there hand in & picks one out. First one drawn wins first prize. This is repeated & as long as the ID hasn't already won a prize (and the winners to date can just have their IDs put onto a table, when a new number is chosen check it isn't on the table), they are a winner. No need for Excel.
    To receive a better answer, put more work into asking the question.


  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    Quote Originally Posted by Fazza View Post
    Surely you must give some rules on how to pick the unique winners?

    How is it done? for example where i'm from, some little bits of paper each with an ID on them are put in a bucket and someone puts there hand in & picks one out. First one drawn wins first prize. This is repeated & as long as the ID hasn't already won a prize (and the winners to date can just have their IDs put onto a table, when a new number is chosen check it isn't on the table), they are a winner. No need for Excel.

    This will all be digital: due to 17,000+ entries.
    Pick 1 Name and then remove that person from any future prizes
    Pick 1-10 Names for 1st tier prize no Duplicates
    Pick 240 Names for 2nd Tier prizes no Duplicates

  4. #4
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,149
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    That doesn't answer my question. Maybe I didn't explain it well enough. I don't know what you want so I can't help you.

    What about?
    Formula =A2 in the top prize winner 1 cell, then drag/fill down to top prize winner 10 cell. This will now be =A11.
    Then formula = A12 in the 2nd prize winners 1 cell, then drag/fill down to 2nd prize winners last cell. This will now be =A251

    If that doesn't help I'll leave it to you & others. all the best
    To receive a better answer, put more work into asking the question.


  5. #5
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,100
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    Quote Originally Posted by ommak View Post
    Example:


    ID Name Entries
    1030568867 a1 64 Top Prize Winners 2nd Prize Winners
    1014727335 a2 58 1 1
    1015596467 a3 57 2 2
    1017253571 a4 56 3 3
    1020105929 a5 55 4 4
    1022773019 a6 55 5 5
    1001899839 a7 52 6 6
    1009823660 a8 51 7 7
    1022910204 a9 50 8 8
    1026919113 a10 50 9 9
    1023942346 a11 49 10 10
    1000818364 a12 48 11
    1012926878 a13 48 12
    1015393840 a14 47 13
    1001047502 a15 47 14
    1033266645 a16 47 15
    1011604625 a17 47 16
    1006711599 a18 47 17
    1031942764 a19 47 18
    1003411111 a20 46 19
    How representative is the quantities column? Will each entry have, on average, about 40 to 50 entries as your sample data shows? I ask because upwards of 20,000 users with that many entries each could possibly overwhelm your computer's resources when trying to randomize the full set of expanded entries.
    Last edited by Rick Rothstein; Jul 26th, 2019 at 03:40 AM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •