![]() Head over to the Ablebits Tools tab > Utilities group, click the Randomize button, and then click Shuffle Cells.If you don't have time to fiddle with formulas, use the Random Generator for Excel tool included with our Ultimate Suite to do a random sort faster. How to shuffle data in Excel with Ultimate Suite To have it done, place two or more columns side by side so that the columns are contiguous, and then perform the above steps. The same approach can be used to randomize multiple columns.Or, simply delete the column with the RAND formula if you don't need it any longer. To prevent the random numbers from recalculating with every change you make to the worksheet, copy the random numbers, and then paste them as values by using the Paste Special feature.So, if you are not happy with how your list has been randomized, keep hitting the sort button until you get the desired result. Excel RAND is a volatile function, meaning that new random numbers are generated every time the worksheet is recalculated.Įither way, Excel automatically expands the selection and sorts the names in column A as well: Or, you can go to the Data tab > Sort & Filter group, and click the ZA button. So, select any number in column B, go to the Home tab > Editing group and click Sort & Filter > Sort Largest to Smallest. Sort the column filled with random numbers in ascending order (descending sort would move the column headers at the bottom of the table, you definitely don't want this).The fastest way to do this is by double-clicking the fill handle: In the first cell of the inserted column, enter the RAND formula: =RAND(). ![]() ![]() If your dataset consists of a single column, skip this step. Insert a new column next to the list of names you want to randomize.How to randomize a list in Excel with a formulaĪlthough there is no native function to perform random sort in Excel, there is a function to generate random numbers ( Excel RAND function) and we are going to use it.Īssuming you have a list of names in column A, please follow these steps to randomize your list: ![]()
0 Comments
Leave a Reply. |