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 - [ Ссылка ]
✅ Free Excel Course (Basic to Advanced) - [ Ссылка ]
✅ Free Dashboard Course - [ Ссылка ]
✅ Free VBA course - [ Ссылка ]
✅ Free Power Query Course - [ Ссылка ]
✅ Best Excel Books: [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
#Excel #ExcelTips #ExcelTutorial
Shuffle List of Names/Items in Excel (2 Easy Methods)
Теги
shuffle names in excelShuffle list in excelRandomize Names in ExcelRandomize list in Excelshuffle list in excelshuffle list of words in excelshuffle list of names in excelrandomize list of names in exceladvanced excelexcelexcel basicsexcel tipsexcel tutorialslearn excelsumit bansaltrump exceladvanced formulasMicrosoft 365Excel 365excel tips and tricksexcel online coursemicrosoft excelexcel tutorialhow to