Create Random Data List based on Existing Data

How to create a Random data list based on an existing Data list. Let say we have a Name list in Range (A1:A5).

 

Step 1: Put below formula in Cell C1 and drag it down:

=INDEX($A$1:$A$5,RANDBETWEEN(ROW($A$1),ROW($A$5)))

Let's look into the formula:

=INDEX($A$1:$A$5,RANDBETWEEN(ROW($A$1),ROW($A$5)))

As all of you know, Row(A1) will return value 1 and Row(A5) will return value 5. Hence, Randbetween function will return the Random data between 1 to 5.

-----------------------------------------------------------------------------------------------------------------------------------------------

Download the file : RandomDataList.xlsx

Thanks for learning, will come soon with new post.

Please provide your valuable feedback in comment box.