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:

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

<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[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:

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

<tbody>
</tbody>

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.