How to randomly select names in excel?

#How to randomly select names using excel?

Method:

#1. First open the personnel list to be randomly checked, and edit the basic Format

2, then open the Insert Function dialog box, select [All] in the category

3, and then find [RANDBETWEEN], click OK

4, then the lowest value and the highest value of the number

5, then Enter [=VLOOKUP(D2,A2:B11,2,FALSE)] in the random check box. You can refer to my previous experience

6, and finally See the spot check number and the corresponding spot checker

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to randomly select names in excel?. For more information, please follow other related articles on the PHP Chinese website!