Random Drawing with Mulitple Entries

[luarwhite]

I am trying to do a random drawing and the entrants may have multiple entries. I would like random draw to take into consideration the number of entries each person has. I have the entrants name in Column A and the Number of Entries for that person in Column B. I have attached an example.

Any help would be appreciated. Thanks.

[martindwilson]

here is one way

[shg]

Another way:

	A	B	C	D
1	Name	Tickets	helper
2	Alan	7	0.0000	C2: =N(B1)/$B$10 + N(C1)
3	Barb	4	0.2692
4	Cain	4	0.4231
5	Dana	3	0.5769
6	Eric	3	0.6923
7	Fran	3	0.8077
8	Gary	1	0.9231
9	Hana	1	0.9615
10	Total	26
11
12	Eric			A12: =INDEX($A$2:$A$9, MATCH(RAND(), $C$2:$C$9))