How to use random grouping method in Excel

How to use the random grouping method in Excel?

1. Open excel and enter a set of data in column A.

Recommended: "Excel Tutorial"

2. Enter the formula in B1: =RAND().

#3. After clicking Enter, pull down the formula to generate data.

#4. Select one of the cells, right-click the mouse and select "Ascending Order" in "Sort".

#5. You can randomly shuffle the data in column A.

#6. Select the first three rows of data and click "Data" in the toolbar.

#7. Select "Group" in "Data" to group the three selected rows of data.

#8. Group the data in other rows in the same way to get a set of random groups in random order.

The above is the detailed content of How to use random grouping method in Excel. For more information, please follow other related articles on the PHP Chinese website!