How to Randomize a List in Excel Into Groups: 5 Suitable Ways

Excel Into Groups Using RAND Function" width="401" height="415" />

This is how you can use the RANDBETWEEN function to randomize Excel lists.

Method 3 – Combine RANDARRAY, SORTBY, and ROWS Functions

Steps:

• Copy the following formula in the selected cell.

• ROWS(B5:B10): Returns the row numbers of the array.
• RANDARRAY(ROWS(B5:B10): Returns an Array according to the ROWS
• SORTBY(B5:B10, RANDARRAY(ROWS(B5:B10))): Returns the newly sorted names and spills the names throughout the whole column.

• Pressing Enter, Excel will show the following result.

Method 4 – Using INDEX and RANDBETWEEN Functions

Steps:

• Write down the following formula in the selected cell.

• RANDBETWEEN(1,6): Returns a random number in a cell between 1 to 6.
• INDEX($B$5:$B$10, RANDBETWEEN(1,6),1): Returns randomly sorted names in a certain cell.

• The following result will be shown.

• Excel will show the following result.

We can randomize a list in Excel using the INDEX and RANDBETWEEN Functions.

Method 5 – Applying CHOOSE and RANDBETWEEN Functions

Steps:

• Write down the following formula in the selected cell.

• CHOOSE(RANDBETWEEN(1,6),$B$5,$B$6,$B$7,$B$8,$B$9,$B$10): Returns the shuffled names in the C column.

• After pressing Enter, the following result will be shown.
• Copy down the formula from C5 to C10

• The following result will be found.

This is the procedure how to randomize a list in Excel into groups.

Things to Remember

• You should bear in mind that the SORTBY function can only be found in Excel 365.

Download Practice Workbook

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft. Read Full Bio