How to Generate a Random List of Names Based On Set List of Names in Google Sheets/Excel

[@TheRealTravelBlog]

I just have to say. Your the best and very thorough in explaining steps and what they mean. I'm a Java noob and its been a struggle to say the least. But your videos are very easy to understand and I can actually understand what is going on and why. I spend hours and hours every day still trying to figure the method to go about completing my first script.

[@Thekeycuts]

Thank you! Keep on working at it you will get it!

[@deemyers5463]

This was amazing!! Thank-you so very much. I have wanted to do something like this since watching other consultants in my small business group do random name drawings when a number of people have multiple entries. My small "spinning wheel" app could only go so far! I followed along with you and your video, pausing when necessary and was so excited when I got it to work!! Thanks so much!

[@Thekeycuts]

Glad this helped!

[@bimbaZen]

Thank you so much. Your video helped me a lot in creating groups of students for my English classes. You just saved me tons of late nights trying to figure it out! :)

[@Thekeycuts]

Glad to help!

[@DiyEcoProjects]

Hi this is cool! Ive used it in a D&D game. I wanted Random Townsfolk to go to Random Locations, doing random things like selling, chatting, arguing, at home or working etc. Thats fun... i now have 26 residents doing random stuff every time i type a letter into another cell. AWESOME!!! that will keep those pesky adventurers guessing where they are AND give a bit of life to the town. [Slugfry Tom the Herbalist] [is at Snot Goblin Inn] [Looks Happy]

[@Thekeycuts]

What a super interesting use case for generating random names. Awesome!

[@DiyEcoProjects]

@@Thekeycuts thank you :) here it is docs.google.com/spreadsheets/d/1pHbe-9esZxXpxZ7SKw-lgYrbYSBNevbNV6DIolTAycw/edit?usp=sharing

[@tvHTHtv]

Thank you! I am doing a follower giveaway for my twitch community. I have about 750 names in a spreadsheet but have been needing a way to randomly select 100 of them to go onto the final selection process. This is EXACTLY what I needed and explained in a very simple and easy to understand manner. Thank you!!!

[@Thekeycuts]

Glad this helped with your follower giveaway!

[@savanhonline5599]

Thank you

[@kevinsue1778]

i want to use 50- 100 names, and have them all randomly mixed up in groups of 5 or 10 names per group if 50 names and 10 -20 names per group if 100 names is this possible?

[@Thekeycuts]

Definitely possible! Would require some editing of the template.

[@samwillows2498]

Hi, if we have another column next to names for example a first and surname split up can we get the random list to then create the 2 seperate columns? I have name, age and height for example and need all 3 to show in the random list - many thanks.

[@shoebert31]

could you make the names go across columns instead of in rows. For example I wanted 5 random names from the list in f-j with no duplicates?

[@Thekeycuts]

Definitely possible!

[@nlesinski4]

ok so I've been trying to random sentence generator... any help with that? I love the video. im not sure what the extra entries are for after the absolutes look ups? the display on the row and columns?

[@TheRealTravelBlog]

Ps if you need an idea for your next video I have it. Lmk if your interested. Thanks.

[@kevinsue1778]

will this work with 100 names in groups of 10?

[@Thekeycuts]

Yes!