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

#google sheets