Every time you make any change to the worksheet, the random numbers will change their value. Select cell C5 again. Go to the Home tab, click on Sort & Filter in the Editing group, and select Sort Smallest to Largest. Your rows will randomize themselves. All the columns have also been ...
SEQUENCE(3) →returns a sequence of numbers. Here,3is therowsargument. Output→ {1;2;3} =INDEX(SORTBY(B5:B13, RANDARRAY(ROWS(B5:B13))), SEQUENCE(3)) →returns a value at the intersection of a row and column in a given range. In this expression,SORTBY(B5:B13, RANDARRAY(ROWS(B5:...
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. Ra...