Microsoft Excel tutorial on randomly sorting a list in Excel.
Buy Bill Jelen's latest Excel book:
www.mrexcel.com/products/latest/ The three formulas in the video
Method 1: =SORTBY(A13:B36,RANDARRAY(24))
Method 2: =SORTBY(A13:B36,RANDARRAY(COUNTA(A13:B36)))
Method 3: =RAND() next to each row and sort by the random column
Welcome to another Excel tutorial! In this
#shorts video, we will be learning how to randomly sort a list in Excel. This is a useful skill to have when working with large datasets or when you want to mix things up in your data analysis. So, let's dive in and learn three different ways to randomly sort a list in Excel.
The first method involves using the SORTBY function. First, we need to count the number of items in our list. In this example, we have 24 items. Then, we use the SORTBY function and select our list as the first argument. Next, we use the RANDARRAY function to generate a random number for each item in our list. Finally, we close the brackets and hit enter. Every time we press F9, a new version of the list will be generated with a different random order.
The second method is useful when you don't know the exact number of items in your list or if the list is constantly changing. We use the COUNTA function to count the number of non-empty cells in our list. Then, we follow the same steps as the first method to generate a new random order every time we press F9. This method is great for dynamic lists that are constantly being updated.
The third method is for those who are using an older version of Excel that does not have the SORTBY function. We simply add a new column and use the RAND function to generate a random number for each item in our list. Then, we sort the data in ascending order and voila! A new random order for our list. Don't forget to like, subscribe, and ring the bell for more Excel tips and tricks. And as always, feel free to leave any questions or comments down below. Happy sorting!
Buy Bill Jelen's latest Excel book:
www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below:
www.mrexcel.com/like-mrexcel-on-youtube/ Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?
#excelfunctions #excelsort #excelrandom #random Table of Contents
(
0:00) Problem Statement: Sort Excel list into random order
(
0:10) Using RANDARRAY function in Excel
(
0:20) Using COUNTA function to count list
(
0:32) Older Excel, use RAND function and Sort
(
0:49) Clicking Like really helps the algorithm
Join the MrExcel Message Board discussion about this video at
www.mrexcel.com/board/threads/1234865/
@GOHSHULIANS2-06
11 months ago
Hi hi, why the result returned as “value”?
1 |