How to Randomize a List in Microsoft Excel
If you want to rearrange items in a list in random order, you can use Microsoft Excel’s RAND function. The function generates random numbers, which allow you to then randomize your list items. Here’s how to do that in your spreadsheet.
Source: howtogeek.com