Shuffle a Data List Using the Formula. To shuffle the data list, we first need to randomize the numbers using the RANDBETWEEN function. After that, we can lookup for data using the VLOOKUP function. The parameter bottom of the RANDBETWEEN function is 1 and the top is 7, as we have 7 items in the table. Drag the formula down to the other cells

See this dummy exam results Excel report. Try to sort, filter, switch pages or change the number of displayed rows in the table to see how the report adjusts

2. Embed VBA to Select Any Number of Random Names from a List. Here, We’ll select a set of random names at a time according to our specified number. For this example, I have modified the dataset. I specified 4 in Cell E4 to select 4 names at a time and will show the output in cells E7:E10.

Using the RANDARRAY function and linking it to a list of first names can create a random order of names. Adding middle names and using the RANDBETWEEN function can further customize the generated random names. Practicing and experimenting with different methods is encouraged to efficiently generate random names in Excel.

Online test data generator. Here you can generate up to 100 combinations of data formats and information and export up to 100,000 records. Build up your test datatable and export your data in CSV, Excel, Json, or even Sql script to create your table. You can use weights, nullable fields and more options to generate test data.

To restore your data is not difficult. You just have to: Switch the column of the name (the code name must be the first column) Create one more time the VLOOKUP to return the original name. Convert the formula in value. Remove the anonymous name. Discover how you can transform your worksheet to anonymise your data in the case you have sensitive

. 800 567 860 490 887 159 355 372

generate random names in excel