Question: do a random sort in excel?
Answer: Click any number in the list in column B. To sort in descending order, on the Data tab, in the Sort & Filter group, click ZA.
Result. A random list in column A (sorted on the random numbers above).
Note: random numbers change every time a cell on the sheet is calculated.