Template for Raffle Generator?

[helari]

Hello,
I would like a template that allows me to create of a randomized raffle. I have no idea how to create one, but need it for a raffle I am holding, where some participants have more tickets than others.

Thank you so much in advance for your consideration. If you would get back to me either way I would appreciate it!

Thank you,

Helen

 

[bbott]

Welcome to the board.

Here's a very simple solution. They may be better ways, but this will work.

As an example, say you sell 15 tickets. Number the cells 1-15 in column A (A1=1, A2=2, etc). If Bob buys 5 tickets and Joe buys 10 tickets, enter the name "Bob" in 5 cells in column B and "Joe" in 10 cells in column B.

Enter this formula in cell C1:

=VLOOKUP(RANDBETWEEN(A1,A15),A:B,2,FALSE)

It will choose a name at random. But please be aware that whenever you change a cell, the winner will change. I hope this will at least get you going in the right direction.

 

[helari]

Thank you! It seems very straighforward. I will try that.

Welcome to the board.

Here's a very simple solution. They may be better ways, but this will work.

As an example, say you sell 15 tickets. Number the cells 1-15 in column A (A1=1, A2=2, etc). If Bob buys 5 tickets and Joe buys 10 tickets, enter the name "Bob" in 5 cells in column B and "Joe" in 10 cells in column B.

Enter this formula in cell C1:

=VLOOKUP(RANDBETWEEN(A1,A15),A:B,2,FALSE)

It will choose a name at random. But please be aware that whenever you change a cell, the winner will change. I hope this will at least get you going in the right direction.