How to make a Raffle in Excel | How to Draw a Name From a List Randomly

How to make a Raffle in Excel | How to Draw a Name From a List Randomly
in this Excel video tutorial we going to see how can we create a raffle and pick a winner through a names list or how can we do a draw from one list of names and pick a winner to do it we can use the randbetween function in Excel and we can also use the vlookup function.
The Randbetween formula in Excel is going to give us a number randomly through a set of values that we can define from a bottom value up to a top value so basically we can define a range and the rand between function is going to draw a number for us.
now with the number of the winner on the screen we can use the vlookup function to bring it back as a result of the name of the winner instead of just to have the number itself so let's say the randbetween function gives to you the number 10 and the vlookup function can look up for the number 10 and bring back the participant name that match with the number 10, that way, you can have both, the number of the winner and also the name of the winner.
#JopaExcel #Dashboard #Excel

[@henrikc79]

straight to the point and easy to follow. thanks!

[@JopaExcel]

Gald you liked it, Henrik 🙏👍

[@Agentkozbee]

Thank you very much for this tutorial

[@maiden5427]

From a mathematical point of veiw,
does the order of the names/items affect the outcome.
I only have 5 participants with 300 entries, all arranged in alphabetical order.

[@DanielSilva19_19]

If I want to create another winner but don't repeat the same name. How do I do it?

[@veiyi]

this is so helpful, thanks!

[@MadstoneAdventures]

Can you set it up so let's say one name has ten chances to win, another has 1, etc to make it like raffle tickets bought?

[@veiyi]

this probably doesn't help you anymore but maybe just straight up put the same name in the list 10 times.

[@MadstoneAdventures]

@@veiyi Thanks. Actually my drawing is in 2 days, but I figured another way around it. What I did is listed the names one time in my list, but I had the conditional format highlight the winner's name for a range of numbers instead of just one.

[@alicec1028]

@@MadstoneAdventures I am looking to do this. Could you explain to me how you used the conditional format to include the range of numbers?

[@MadstoneAdventures]

@@alicec1028 I found a way to do it. It is not the most elegant way to do it, but I would be happy to share what I did. I might be a little complicated to explain because it is elegant in its simplicity, but took some setting up.

[@MadstoneAdventures]

@@alicec1028 for the first person, I put person's name in column B4. in column C4 I put "1". In column D4 i put a hyphen. in column F4 I put the number of tickets they bought. In column E4, I put the number of tickets they bought.
Then for every name after the first this is what I did. for example for second person, I put name in B5. In column C5, I put the equation 1+E4. I put hyphen in column D. I put the number of tickets that they bought in F5. Then I made E5=C5+F5. then you continue that pattern for every name.
I created a box in my sheet that had value equal to the largest number in column E. The cell location of the largest value of E was E24.
Then to get a winner I created another box E25=RANDBETWEEN(C4,E24) where if you remember C4=1 and E24= largest number of tickets. Now with the column with the hyphen in it you have the range for each person. So, you just have to figure out where the number falls.
I went an extra step and put in a condictional formatting for every row in my chart. So, the conditional formatting would check for the value in E25 and then highlight the row based on the value of E25. It was a pain in the but setting up every conditional format because if the values in your chart change, you have to update the conditional format as well to make sure they still match.
I would send you my excel file, but like me you probably don't want to publish your email for the world to see. I hope that helps.