Weighted Random Number Generator for Raffle

Hi there,

I am trying to create a raffle in excel but no luck so far. I have about 200 people in the raffle, all with multiple entries ranging from 1-150 or so. My data currently looks like this:

Column A: Names of participants
Column B: Number of entries

I would like to create a function that helps pick a winner for 5 different prizes, with no participant being able to win more than 1 prize.

I hope something like this is possible. Let me know if any additional information is helpful. I am new to this.

Thanks in advance.

Hi thanks! I think the macro will help. Again, new to macros, but how can I edit it to show the results one row down?

Thanks! This is great! Is there a way to have a delay between the display of each line/winner? So that line 5 would appear, then line 4, and so forth.

Thanks again for all the help!

Hi again,

Is there a way to have a delay between the display of the results? Thanks!

This is exactly what I needed! Thanks a Mil!

Hello I hope you can still answer a question or two for me. First let me say what you got is great! I need to have the possibility to draw the same person more than once. I also want to be able to either pause the macro before the winners are picked or at least split the macro so only the table is filled and then another button is used to pick the winners (i want to randomize the entries in col D before picking winners). The raffle is 2000-3000 tickets and there will be a wide variation of ticket holdings ie. (1 person has 1 ticket while another has 500) i really don't want 500 entries in order together. I know every little about macro scripting and have been messing around, can get the full table to work alone but can't pick winners in a separate macro (I imagine because certain variables aren't defined, but i'm not sure what to change/add). Thanks.

I realize I'm necroing this post but is there a way that instead if 5 winners there could instead be 20 or 30? I cant seem it fugure it out without redoubg the formula all over again. Im just looking to see if someone can point me in the right direction on where i can edit to either add or remove winners.