how to random sort in excel

原创 admin 2021-01-08 16:40 

This article teaches you how to randomize (shuffle) a list in Excel. For example, we want to randomize the list in column A below.

1. Select cell B1 and insert the RAND() function.

2. Click on the lower right corner of cell B1 and drag it down to cell B8.

Add Random Numbers

3. Click any number in the list in column B.

4. To sort in descending order, on the Data tab, in the Sort & Filter group, click ZA.

Sort in Descending Order

Result. A random list in column A (sorted on the random numbers above).

Random List in Excel

Note: random numbers change every time a cell on the sheet is calculated. If you don't want this, simply copy the random numbers and paste them as values.

版权声明: 本文为4find – 解决程序猿问题原创文章,欢迎转载。转载请务必注明出处! (参考格式:本文转自4find – 解决程序猿问题,原文地址: