How to do random grouping with excel software

Steps:

1. Open the Excel software, randomly select a list (take column A as an example), and enter the number 1- 10.

2. In the first line next to the column, enter the formula: =RAND ().

3. Enter to drop down the formula just entered to generate data.

4. Select any cell, click the right mouse button, find the "Sort" option, click Open, and select "Ascending Order".

At this point, we can see that the order of the numbers in the first column is out of order.

6. Select the data in the first three rows, and then click the Data option in the toolbar.

7. Open the "Data" option again, find "Combination" and select it to group data.

8. By the same token, we can get a group of randomly grouped scrambled data by repeating the operation on the data to be scrambled.