There might be occasions when you a list of values and you need to re-order the list in a random fashion.
For instance, you might have a list of surnames in alphabetical order of people that work in your company and you want to randomly re-order it.
Doing so would allow you to make a picking order fairer.
You can achieve this result by using the RANDBETWEEN function in Excel.
First of all, add an increasing series of numbers in the column before the list of surnames.
Next, compose the RANDBETWEEN function in the cells next to the first instance of where you want your list to appear.
The RANDBETWEEN function generates a random integer between two values (Bottom and Top) which you need to specify when you insert the function.
In this particular case my function will be =RANDBETWEEN(1,27)
Next you will use the random number generated to select a particular value in the original list using the VLOOKUP function.
This value will populate the first cell in your random list.
Copy and paste the two cells to create a random list as long as you need.
As usual I have recorded a video to show you the whole process of how to create a random list in Excel in detail, step by step.