How to do simple random sampling with EXCEL?

1, if the employee code is in column A;

2. Enter "=RAND ()" in B 1 and fill it down to b1000; ;

3. Select column B, click data in the toolbar → ascending order, select "Expand Selected Area" in the pop-up window, and then click the "Sort" button. At this time, the serial number of column A has been disrupted, and the requirement of "50 artificial samples" can be achieved by directly looking at the values in A 1 to A50.

be good at

Microsoft Excel is one of the components of Microsoft office. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems.