1 min readfrom 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.

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

Want to read more?

Check out the full article on the original site

View original article

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
Random winner selection, entire row issues.