How to run for the class committee at random, if you want to randomly select from the excel list? .

To run for the class committee at random, the specific steps of randomly selecting from the excel list are as follows:

The materials to be prepared are: computer, Excel form.

Take win7 system and Excel table 20 10 as examples:

1. First open the Excel table and enter the editing page.

2. Then enter the formula in the cell after the name: =RAND () cell.

3. Then click the cell at the back to enter the format: c 1 = index (a: a, match (small (b $1:b $100, row (a 1)), b $1:.