Random list generator in excel8/8/2023 If you’re using Excel for Microsoft 365 or Excel 2021, you can use the first method where I use the SORTBY and RANDARRAY function.Īnd in case you are using older versions of Excel, then you can use the second method where I use the RAND function. These are two simple ways that you can use to shuffle a list of names or items in Excel. Once done, you can delete the numbers in column B. Now you can sort the list of names based on this new random number dataset and you will have the new shuffled list of names. This will force the RAND formula to recalculate and it will give you a new set of random numbers. In case you want to shuffle the list again, just hit the F9 key. The above steps would sort the list of names based on the random numbers we generated. In case you don’t have access to SORTBY and RANDARRAY functions, you can randomize the list the old-fashioned way.īelow I again have the list of names that I want to shuffle and get a new list. You can also open an existing Microsoft Excel document if you have one that correlates to your random sample needs. Also read: Separating First and Last Names in Excel Randomize List Using RAND Formula + SORT Feature (for Older Excel Versions) If that’s the case with you, you can use the method covered next. In case you’re using an older version of Excel, you won’t have access to these functions. Note that both ‘SORTBY’ and ‘RANDARRAY’ are new formulas and are only available in Excel for Microsoft 365, Excel 2021, and Excel for the Web. Once you have the list of random names you want, you can convert the formula to values so that it doesn’t change again. In case you want to shuffle this list again, hit the F9 key and the list would shuffle again (this happens because RANDARRAY is a volatile function and refreshes whenever you hit F9 or make a change in the Excel file) This random list of 14 numbers is then used within the SORTBY function to give us the shuffled list of names. I have used the COUNTA function to get the total number of names in the list, which is then used within the RANDARRAY function to generate a list of 14 random numbers (as there are 14 names in the list).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |