Read More: How to Shuffle Numbers in Excel Method 4 – Applying the INDEX and the RANDBETWEEN Functions to Create Randomized Samples Click here to enlarge image To choose a random major, use the formula. =INDEX(B5:C8,RANDBETWEEN(1,4),2) Formula Breakdown RANDBETWEEN(1,4): generates a ra...
The result is a randomized list without duplicates. Read More: List of Names for Practice in Excel Method 2 – Utilizing the INDEX, RANK.EQ, and COUNTIF Functions Steps: Go to C5 >> use the RAND function to generate a random value >>Drag down the Fill Handle to see the result in th...
You may also be interested in How to select random sample in Excel Get random selection without duplicates How to generate random numbers in Excel How to generate random numbers without duplicates How to sort by date in Excel How to sort and filter by color in Excel...
Note:TheExcel RAND functionis volatile: It recalculates its result on every worksheet change. So, the numbers in column B changed instantly after sorting. If you want to shuffle the list again, repeat the abovestep 3. Otherwise, you could simply delete the column with the RAND function. ...