•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Raffle Ticket Winner - Weighted By # of Entries
Our take
Running a raffle can be exciting, but managing entries—especially when participants buy multiple tickets—can quickly become overwhelming. If you're struggling to randomly select a winner in Excel or Google Sheets without duplicating entries for each ticket purchased, you're not alone. Fortunately, there's a straightforward approach that leverages built-in functions to ensure each ticket's weight is accurately represented in the draw. Continue reading to discover a simple method that will streamline your raffle process, making it easy to replicate for future prizes.
Hello! I'm looking for some help randomly generating a raffle winner within Excel/Google Sheets. Some participants have purchased 100 tickets so copying/ pasting their info 100 times is not doable. Is there a way to do this with my data as is?
Everything I've looked up does not take into account the # of tickets purchased. I will need to recreate this several times for different prizes! Any help appreciated, thank you!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need to select a "random winner" from our excel list and record it?Looking for best suggestions to give out a prize from a fundraiser my local trail organization is conducting. I am able to export all entrants to excel but not sure how to randomly select the winner? Ideally we also record the process to prove that it was actually selected randomly. Is there a function in excel that can capture the randomization? Or suggested software to do that? Thanks!! submitted by /u/Torian17 [link] [comments]
- Random winner selection, entire row issues.I am trying to randomly pick winners. I have 500 submissions and picking 20 winners. each table is formatted with their f.name, l.name, email, phone number. I am trying to do a formula to pick those 20 winners using =INDEX(A1:A500,RANDBETWEEN(1,500)). I am getting the names randomized with my 20 selection however it is not giving me the entire row to easily contact these people. what would I need to do to randomly pick the 20 people and have the entire row populate. submitted by /u/OkEstablishment3418 [link] [comments]