Turn on step reading mode
Tool materials:
A computer with an Excel program installed.
operational approach
0 1
If the data is in column A: D of Sheet2, insert two auxiliary columns before column A of Sheet2;
02
In the name box in the upper left corner, enter A2:A953, press enter, select cell A2:A953, press enter =RAND (), press Ctrl+Enter to end, and quickly enter a random number in cell A2:A953 (random number repetition probability is extremely low);
03
Enter the following formula in cell B2, and then fill it down to get the ranking of column A data (no duplicate ranking).
=RANK(A2，A:A)
04
Enter the following formula in cell A2 of Sheet 1, and then fill the formula down to cell D36 1 to obtain 360 rows of non-duplicate data randomly obtained from the Sheet2 worksheet.
=VLOOKUP(ROW()- 1，Sheet2！ $B:$F, column (B 1), 0)
Formula expression: Match the corresponding row in column B of Sheet2 with the current row number accurately, and return the corresponding data in column 2 (column C of Sheet2).
05
When fetching data at random, as long as one data is entered in the worksheet, a set of data will be retrieved in "automatic calculation". Therefore, column A of Sheet2 can be used as "value" for "copy" and "paste selectively" to avoid continuous data conversion. Or set the calculation option in the formula options to manual.
Special tips
The method of obtaining random function through RANDBETWEEN function will cause data duplication, which will not achieve both random and unique purposes. It is better for RAND to obtain a list of non-repetitive random numbers and reorder them scientifically and effectively.