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...
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...
3. In the pop-up dialog box, select "Expand the selection", and then click on "Sort". Result Now, you are all set! The list is randomized as shown below. Note: TheExcel RAND functionis volatile: It recalculates its result on every worksheet change. So, the numbers in column B chan...
Excel RAND is avolatilefunction, meaning that new random numbers are generated every time the worksheet is recalculated. So, if you are not happy with how your list has been randomized, keep hitting the sort button until you get the desired result. Toprevent the random numbers from recalculati...