Shuffle List of Names/Items in Excel (2 Easy Methods)
In this video, I will show you two easy methods you can use to shuffle (randomize) a list of names or items in Excel.
The first method uses the SORTBY and RANDARRAY function, which are available only in Microsoft 365, and the second method uses the RAND function, which will work in any version of Excel.
00:00 Intro
00:11 Shuffle List of Names/Items using SORTBY formula
02:58 Shuffle List of Names/Items using RAND + SORT technique
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
Видео Shuffle List of Names/Items in Excel (2 Easy Methods) канала TrumpExcel
The first method uses the SORTBY and RANDARRAY function, which are available only in Microsoft 365, and the second method uses the RAND function, which will work in any version of Excel.
00:00 Intro
00:11 Shuffle List of Names/Items using SORTBY formula
02:58 Shuffle List of Names/Items using RAND + SORT technique
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
Видео Shuffle List of Names/Items in Excel (2 Easy Methods) канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![4 Easy Ways to Remove Parentheses in Excel](https://i.ytimg.com/vi/nIb5SDfmE-Q/default.jpg)
![How to Create QR Code In Excel (QR Code Generator)](https://i.ytimg.com/vi/Wfu4WZgQqw0/default.jpg)
![3 Easy Ways to Calculate Ratios in Excel](https://i.ytimg.com/vi/LAb79zqRIjA/default.jpg)
![3 Easy Ways to Select Every Other Row in Excel (Select Alternate Rows)](https://i.ytimg.com/vi/03j5J2IeKcM/default.jpg)
![How to Remove Dashes in Excel (4 Easy Ways)](https://i.ytimg.com/vi/DyDn6aYmfC4/default.jpg)
![How to Filter by Color in Excel (Cell Color or Font Color)](https://i.ytimg.com/vi/ZCmQeLhhuvM/default.jpg)
![3 Right Ways to Delete Blank Columns in Excel](https://i.ytimg.com/vi/PvcGzTd7wfc/default.jpg)
![Convert Second to Minutes in Excel (3 Easy Ways)](https://i.ytimg.com/vi/mpIlTCr_bHw/default.jpg)
![Zoom-In and Zoom-Out in Excel 🔍 (Shortcuts)](https://i.ytimg.com/vi/6Rxh1pqej2M/default.jpg)
![AutoFill Only Weekdays in Excel (2 Quick Ways)](https://i.ytimg.com/vi/EE_QVmISAM0/default.jpg)
![Separate Text and Numbers in Excel (4 Easy Ways)](https://i.ytimg.com/vi/WoTzvQ4uNE4/default.jpg)
![Creating Dynamic Monthly Calendar in Excel (Interactive Calendar)](https://i.ytimg.com/vi/o1V2Fdygajo/default.jpg)
![Sum Cells Based on Their Color in Excel (Formula & VBA)](https://i.ytimg.com/vi/G_m2Fu6JZjM/default.jpg)
![Extract Weekend Dates for Any Month in Excel (Clever Formula)](https://i.ytimg.com/vi/DSzVrA7huJE/default.jpg)
![How to Extract Last Name in Excel (3 Easy Ways) | No Formula Used](https://i.ytimg.com/vi/ASIFXTgaN_Y/default.jpg)
![Get the Sheet Name in Excel (Easy formula)](https://i.ytimg.com/vi/IuMs96ak3tg/default.jpg)
![Get the Day Name from Date in Excel (3 Easy Ways)](https://i.ytimg.com/vi/lM06t4TcdzY/default.jpg)
![Add Months or Years to a Date in Excel (Easy Formula)](https://i.ytimg.com/vi/W9uYoAVxtzQ/default.jpg)
![Calculate Slope and Intercept in Excel (Formula + Scatter Chart Technique)](https://i.ytimg.com/vi/lOE7cYhsKKM/default.jpg)
![Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query)](https://i.ytimg.com/vi/zJSNdWFnVus/default.jpg)