Home  >  Article  >  Topics  >  How to randomly group seats using excel roster?

How to randomly group seats using excel roster?

coldplay.xixi
coldplay.xixiOriginal
2020-07-03 10:25:1310039browse

How to randomly group seats in excel roster: first fill in all the seats in order, add a column next to the "seat" column, enter "=rand()"; then double-click the lower right corner [ ] ; Then select "Seats" and "Auxiliary Column" and click "Sort"; finally set the keyword to "Auxiliary Column" and click "OK".

How to randomly group seats using excel roster?

How to randomly group seats in excel roster:

1. First, open your roster table and sort it in order Fill all seats.

How to randomly group seats using excel roster?

#2. Add a column next to the "seat" column and enter "=rand()", so that the first random number will be obtained.

How to randomly group seats using excel roster?

#3. Move the mouse to the lower right corner of the cell. After the mouse changes to a " ", double-click it to fill in the random function formula.

How to randomly group seats using excel roster?

4. Select "Seats" and "Auxiliary Column" and click "Sort".

How to randomly group seats using excel roster?

#5. Set the keyword to "auxiliary column", and then click "OK".

How to randomly group seats using excel roster?

#6. In this way, everyone’s seat numbers will be randomly disrupted. Finally, just delete the auxiliary column.

How to randomly group seats using excel roster?

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to randomly group seats using excel roster?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn