Details are as follows:
1. We open the excel table in the computer, then insert a column before the target data, and then establish the serial number of the target data to be sampled, as shown in the figure.
2. Then we enter =RANDBETWEEN (smallest integer, largest integer) in cell C2, and the largest integer should be equal to the maximum number of serial numbers in column A, as shown in the figure.
3. Then in the function parameter window, we will find the smallest integer returned by the bottom function and the largest integer returned by the top function, as shown in the figure.
4. After that, we can enter =VLOOKUP(C2, A:B, 2,0) in cell D2, and then we can randomly extract data, as shown in the figure.
5. Then we use the VLOOKUP function in the function parameter window, that is, look up the specified value in the first column of a table or numeric group and return the value in the custom column in the current row of a table or array, as shown in the figure.
6. The formula =VLOOKUP(C2, A:B, 2,0) means that the row with the same C2 value is always found in columns A and B, and then the value of the second column is returned, as shown in the figure.
7. Then we can press F9 on the keyboard to generate different random numbers and extract different data, as shown in the figure.
The above is the method that Bian Xiao taught you to randomly extract data from EXCEL tables. I hope I can help you to randomly select one or two numbers in the excel worksheet. It can be realized by function, but it is very troublesome and inefficient. How to quickly and randomly extract data?
Turn on step reading mode
Tool materials:
excel20 16
operational approach
0 1
In the excel worksheet, randomly select one or two numbers.
02
Select data area, repeat at random, and extract at random.
03
Select the extraction times. Leave the selected cell blank, select a storage location, and then finish.
04
If the selected cell data is deleted, please select the selected cell and leave it blank.
05
Select the storage location, confirm, quickly and randomly extract data, and finish.
In excel worksheets, randomly extracting one or two numbers can be realized by functions, but it is very troublesome and inefficient. How to quickly and randomly extract data?
Turn on step reading mode
Tool materials:
excel20 16
operational approach
0 1
In the excel worksheet, randomly select one or two numbers.
02
Select data area, repeat at random, and extract at random.
03
Select the extraction times. Leave the selected cell blank, select a storage location, and then finish.
04
If the selected cell data is deleted, please select the selected cell and leave it blank.
05
Select the storage location, confirm, quickly and randomly extract data, and finish.