How to generate a random list in Excel

  • Sharebar

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.

Starting Point for Random List in Excel

Starting Point for Random List in Excel

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.

Add numbers next to the list

Add numbers next to the list

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)

RANDBETWEEN function to generate Random List in Excel

RANDBETWEEN function to generate Random List in Excel

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.

VLOOKUP function to generate first value of Random List in Excel

VLOOKUP function to generate first value of Random List in Excel

Copy and paste the two cells to create a random list as long as you need.

A Random List in Excel

A Random List in Excel

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.

About the Author

Leave a Reply




If you want a picture to show with your comment, go get a Gravatar.