Shuffle List of Names/Items in Excel (2 Easy Methods)
Рет қаралды 69,760
Күн бұрын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 - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial
@trumpexcel 2 жыл бұрын
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
@anilpaul2912 2 жыл бұрын
I have question regarding excel, how to match exact words or letter like eg: Anil-C1 AnilPaul-C1 so i need C1 status both have and confirmed, pls how to do this
@sandymilton7633 Жыл бұрын
I felt like I gave birth - I was so proud of my shuffled list after following your video. Thanks
@wayneedmondson1065 2 жыл бұрын
Great tips Sumit! Thanks for demonstrating. Thumbs up!!
@robertregal4308 Жыл бұрын
Excellent explanation!
@mohammadalbizri2013 2 жыл бұрын
Welcome back again !
@IvanCortinas_ES 2 жыл бұрын
Excellent tutorial. Much better with the first method. Thank you Sumit!!
@trumpexcel 2 жыл бұрын
Thanks Ivan.. Glad you liked the video :)
@faina_yevheniia Жыл бұрын
Thank you very much!
@mohammadilyas2240 2 жыл бұрын
Excellent زبردست nice tutorial
@generalknowledge5423 2 жыл бұрын
My life is going bcoz of you sir
@Niovo Жыл бұрын
Thank you so much for this video have been strugling with randomising answers to a old multiple question exam! Your first method worked like a dream :)
@djamelbek7506 2 жыл бұрын
i like your video and your lessons have supported me in my duty iam working with indian campany in Algeria Larsen and Toubro
@trumpexcel 2 жыл бұрын
Glad you're finding the videos useful :)
@djamelbek7506 2 жыл бұрын
@@trumpexcel yes specialy the video of vlookup with column for finding the duplicate value my regards from Algeria
@bharaths1171 5 ай бұрын
It is very useful thank you
@gtrademy0205 9 ай бұрын
thanks for the useful tips
@sameer2532 2 жыл бұрын
Sorry, here was a blank row, this is very useful for me, thank you
@Dany-ns6hg 2 жыл бұрын
Nice one, learned something new
@imanihasani850 Жыл бұрын
Thank you
@salmaalaa6158 2 жыл бұрын
very nice video thank you
@Donkeys_Dad_Adam 2 жыл бұрын
Instead of right clicking on the selection, then right clicking again to paste values, you can use the ADDM (Alternate Drag and Drop Menu) by right clicking on the right border of the selected range, drag to another location *while holding the right mouse button down, then dragging back to the original location. This will open the ADDM and there's an option to "Copy here as Values"... That is a super fast way to grab a selected range of cells and paste them back to the original location as values with a flick of the wrist.
@gamingindia8251 2 жыл бұрын
Thanks is helps me to create music jukebox
@zzzzzzzaaaaaaaaaaaaaaa2218 2 жыл бұрын
What is the objective of using ShortBy formula?
@trumpexcel 2 жыл бұрын
SORTBY formula sorts the data based on RANDARRAY output. So you can the shuffled list with this formula itself.
@nandhishwarans2916 Жыл бұрын
I'm working on a list that has 3 columns. When I use the rand function, 2 of the columns get shuffled properly but 1 is totally not in sync. What am I missing here?
@redhaakhund1271 2 жыл бұрын
what is I have 5 column and I want sort by Date? can you please show how? thanks
@anilpaul2912 2 жыл бұрын
I have question regarding excel, how to match exact words or letter like eg: Anil-C1 AnilPaul-C1 so i need C1 status both have and confirmed, pls how to do this
@codeflick1225 Жыл бұрын
how to shuffle columns without duplicate or zero value... Please Help?!
@sameer2532 2 жыл бұрын
sir I Am using this formula with 85 rows, 1 result is showing 0, how to fix that plz reply me thank you in advance
@kingsnow6718 2 жыл бұрын
Sortby not available in sheets any other option for sheets
@dinesh_ms Жыл бұрын
its only available on newer versions of excel
@racheljennings8749 7 ай бұрын
Mine keeps #SPILl! And I don't know why
@anilpaul2912 2 жыл бұрын
I have question regarding excel, how to match exact words or letter like eg: Anil-C1 AnilPaul-C1 so i need C1 status both have and confirmed, pls how to do this
超人夫妇
Рет қаралды 42 МЛН
Chester Tugwell
Рет қаралды 47 М.