I have a list of "people"(column A) who may or may not have made their bonus(column B says YES or NO). So column C has the list of people who from Column A who have meet the criteria "YES" in column B. Now in Column E I have to pick 20 people who made their bonus from Column C at random and put them in alphabetical order. Names can be picked more than once.
This is the code I am using. I need to know how to randomly pick 20 people and place them in alpha numeric order. Note the "people" use their employee code which looks like this: G209425 (1 letter followed by 5 numbers)
=INDEX($E$1:$E$60,RANDBETWEEN(1,60))
Aucun commentaire:
Enregistrer un commentaire