Please click to enter a picture description.
Select the cell where "rand ()" is located, move the mouse to the lower right corner of the cell, turn it into a double cross, and then double-click to fill the formula into other cells.
Please click to enter a picture description.
This results in a series of random numbers ranging from 0 to 1. Copy this column and optionally paste it as a numeric value.
Please click to enter a picture description.
Select all the data, and then click the D sort button under the data menu.
Please click to enter a picture description.
Use the new keyword to set the title of the column, then sort it in ascending numerical order, and then click OK.
Please click to enter a picture description.
In this way, the random sorting of data is realized.
Please click to enter a picture description.
After sorting, delete the auxiliary column.
The magical function of 13Excel sorting-sorting according to the user-defined order
9 The Magic of 9Excel Sorting-Sorting by Keyword
The wonderful use of 3Excel sorting-automatic addition of rows and automatic separation of odd and even rows
Please click to enter a picture description.