How to make a random roll call table in Excel_one function

Do you know how to make a random roll call table using Excel? PHP editor Strawberry brings you a simple and efficient method, which can be easily implemented with only one function. This article will introduce in detail how to use the RANDBETWEEN function to randomly select names, allowing you to easily manage roll call work in classes or activities. Come and find out!

First we list everyone’s names into a table, and then create a table in the following style.

Then enter the function in the roll call box:

=INDIRECT("a"&RANDBETWEEN(3,12))

This RANDBETWEEN (3,12) means randomly selecting 3 to 12, with an A merged in front, indicating A3 to A12, which corresponds to the cells of all the names in the name column. Putting an INDIRECT on the outside means that the contents of cells A3 to A12 are randomly selected.

After filling in the form, press Enter, and then click F9 to draw a random drawing. You can also hold down F9 to simulate the lottery scene.

The above is the detailed content of How to make a random roll call table in Excel_one function. For more information, please follow other related articles on the PHP Chinese website!