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

[ommak]

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:


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

 

[Fazza]

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.

 

[ommak]

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

 

[Fazza]

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

 

[Rick Rothstein]

Example:


[TABLE="width: 717"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Entries[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1030568867[/TD]
[TD]a1[/TD]
[TD="align: right"]64[/TD]
[TD][/TD]
[TD][/TD]
[TD]Top Prize Winners[/TD]
[TD][/TD]
[TD]2nd Prize Winners[/TD]
[/TR]
[TR]
[TD="align: right"]1014727335[/TD]
[TD]a2[/TD]
[TD="align: right"]58[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1015596467[/TD]
[TD]a3[/TD]
[TD="align: right"]57[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1017253571[/TD]
[TD]a4[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1020105929[/TD]
[TD]a5[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1022773019[/TD]
[TD]a6[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1001899839[/TD]
[TD]a7[/TD]
[TD="align: right"]52[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1009823660[/TD]
[TD]a8[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1022910204[/TD]
[TD]a9[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1026919113[/TD]
[TD]a10[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1023942346[/TD]
[TD]a11[/TD]
[TD="align: right"]49[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1000818364[/TD]
[TD]a12[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1012926878[/TD]
[TD]a13[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1015393840[/TD]
[TD]a14[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1001047502[/TD]
[TD]a15[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1033266645[/TD]
[TD]a16[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1011604625[/TD]
[TD]a17[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1006711599[/TD]
[TD]a18[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1031942764[/TD]
[TD]a19[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1003411111[/TD]
[TD]a20[/TD]
[TD="align: right"]46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.