How to randomly select names in excel?
- 烟雨青岚Original
- 2020-06-23 15:56:4616672browse
#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!
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
Previous article：What is the maximum number of rows in excel?Next article：What is the maximum number of rows in excel?