Get instant live expert help on how to randomly select names in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
i want to select unique names randomly based on 2 conditions
Solved by G. A. in 18 mins
I have 600 responses in one group and i need to randomly select 20% of them, in the next group i have 20 responses and i need to randomly select 80% of them. Any help?
Solved by K. U. in 16 mins
I need a formula to randomly pick two list of names (first name and last names) so i can randomly generate names for my spreed sheet
Solved by G. W. in 27 mins
I learned how to create a macro button but i can't figure out the formula i need to make excel sort through a list of names and randomly pick one once you click the button. Button is on sheet 1 and the names are listed on sheet 2 in the same workbook.
Solved by S. H. in 30 mins
I have 10 groups of 10 names in a column, and need a formula for Excel to output a name when someone randomly chooses first a group, and then one of the names in that group, but does both things at the same time
Solved by Z. C. in 28 mins