1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Raffle Ticket Winner - Weighted By # of Entries

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!

https://preview.redd.it/quoaj1julqlg1.png?width=1802&format=png&auto=webp&s=c49a7903cec4f6e8ba787735128fe5d801983623

submitted by /u/bangtanforever777
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#google sheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#raffle
#ticket
#winner
#Excel
#Google Sheets
#entries
#randomly generating
## of tickets
#participants