Excel - Random Name Generator - Excel Tutorial Pt 10

preview_player
Показать описание
Using the Random Between and Index formulas to select names randomly from a list. Ideal for use in school classrooms, pub quiz's etc. Here is formula to Copy & Paste.
=INDEX($A$1:$A$15, RANDBETWEEN(1, 15))
Рекомендации по теме
Комментарии
Автор

Thank you! I am looking to creating a prefix, base, suffix lesson with this idea. Thanks again!!

tammiemurray
Автор

Thanks for the tutorial, it was very informative. However, can you explain how to random select 10 names in one draw?

WRMLife
Автор

How could you adapt this to generate 2 or more names?

jpbrose
Автор

Can this apply with images instead of names?

stephanieanderson