•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Random winner selection, entire row issues.
Our take
To randomly select 20 winners from your 500 submissions while ensuring you capture the entire row of information for each winner, you'll need to adjust your approach. Instead of using the formula =INDEX(A1:A500,RANDBETWEEN(1,500)), which only retrieves specific names, consider using a combination of the UNIQUE and RANDBETWEEN functions. Create a helper column that generates random numbers for each entry, then sort your data by this column.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Raffle Ticket Winner - Weighted By # of EntriesHello! 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]
- 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]