mercredi 12 juillet 2017

pick random names from a list

I am trying to use a formula that it will allow me to pick 183 names randomly from a list of 355 names. My excel sheet will look something like this:

Names  Random.Names

Paty     
Oscar
John
Anna
Jane
Carlos
Maria
Jennifer
Susan
Kayla

On my actual sheet I have more names but this is just an example. I used the following formula but I have a few cells that show #REF after it randomizes.

=IF(ROWS($1:1)>$E$2,"",INDEX($A$8:$A$355,RANDBETWEEN(1,354)))

Please let me know if you have a better formula or if you know what I am doing wrong.

Thank you in advance for your help.

Graciela




Aucun commentaire:

Enregistrer un commentaire