Random name draw for multiple weighted entries with no duplicates

[excelquestion515]

I have a list of names / entries for a raffle where some people have multiple entries. I want to draw multiple winners and want to ensure those who have multiple entries are weighted accordingly, however once someone has won they should be unable to win a second time. How would this be done in excel?

 

[Cubist]

Maybe this.

Book1
	A	B	C	D
1	A	# of winners	2	F
2	A			A
3	A
4	A
5	A
6	B
7	B
8	C
9	C
10	D
11	E
12	F
13	G
14	E
15	E
16	K
17	L
Sheet4

Cell Formulas
Range	Formula
D1:D2	D1	=TAKE(UNIQUE(SORTBY(A1:A17,RANDARRAY(ROWS(A1:A17)))),C1)
Dynamic array formulas.