0:00
Sorting an Excel table randomly isn't a built-in feature like sorting in ascending or descending order
0:05
However, you can achieve this with a workaround. One common approach is to add a column with random numbers and then sort the table based on that column
0:13
In an empty column next to your data, use the RAND formula in the first row of the column
0:17
and drag it down to fill the entire column with random numbers. This function generates a random number between 0 and 1
0:24
Now simply click the drop-down arrow next to the random values, header, and choose either ascending or descending order
0:29
It doesn't matter because the numbers are random. This method effectively shuffles the rows of your table randomly
0:35
achieving the result you're looking for. If you don't need the random number column in your final sorted table
0:40
you can delete it after sorting. If your data is organized in cells rather than being formatted as a table
0:45
you can still efficiently sort it in ascending or descending order based on one or more columns
0:50
This can be achieved by selecting the data range, accessing the data tab, and utilizing the sort icon
0:56
Now, to random sort your data. In an empty column next to your data
1:00
use the RAND formula in the first row of the column and drag it down to fill the entire column with random numbers
1:06
Select the entire data including the column with random numbers. Go to the data tab, click on sort
1:12
and select the column with random numbers as the sorting criteria. Choose either ascending or descending order
1:17
It doesn't matter because the numbers are random. If you don't need the random number column in your final sorted table
1:23
you can delete it after sorting. Thanks for watching. If you found this information helpful
1:27
be sure to give it a thumbs up and subscribe for more helpful tips and tutorials
