•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#financial modeling with spreadsheets
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives