Random Name Selector: Easy Guide to Picking Names from a List

Рет қаралды 70,628

Күн бұрын

Welcome to "Random Name Selector" video, where we make picking names from a list as easy as pie! Whether you're organizing a giveaway, selecting a lucky winner, or just deciding who's next for a fun game, our tutorial has got you covered. We'll walk you through the simplest, most efficient methods to ensure fairness and excitement in every selection. Stay tuned as we unveil tools, tips, and tricks that transform this mundane task into a thrilling experience. Perfect for teachers, event organizers, and anyone in need of a random pick, this video promises to be your go-to guide for all things random. This video will show you how to do that with the RAND, RANK, MATCH and INDEX functions. You'll even get to see Flash Fill in action. A short but feature packed video this is...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Пікірлер: 59

@DougHExcel 4 жыл бұрын

For more videos that cover random number or value generation see kzfaq.info/sun/PL-n8f1cY_Qw_FyrtQzHiqktUC6PuqEzQE

@DougHExcel 3 жыл бұрын

...

@primahadi_wijaya 3 жыл бұрын

That “flash fill” thing is a star!! I always use the concatenate function in that situation! Really glad to find your video, Doug.

@DougHExcel 3 жыл бұрын

Awesome! Thank you!

@danaaustinspeaks6730 3 жыл бұрын

You are a great, event paced teacher!

@DougHExcel 3 жыл бұрын

Thank you! 😃

@Luciano_mp 5 жыл бұрын

Good tip, Thanks Doug!

@DougHExcel 5 жыл бұрын

You're Welcome!

@ZAHIDHUSSAIN-ri5kg 5 жыл бұрын

Many, many thanks Doug!

@DougHExcel 5 жыл бұрын

You're Welcome!

@Dauda100 5 жыл бұрын

Learned alots from you Doug.

@DougHExcel 5 жыл бұрын

Thanks!

@joegurto 2 жыл бұрын

Thank you. Just what I was looking for.

@DougHExcel 2 жыл бұрын

Glad I could help!

@johnclarke1319 Жыл бұрын

thanks, clear as mud

@DougHExcel Жыл бұрын

John Clarke, that is very interesting...thanks for letting me know.

@LaRedCR 3 жыл бұрын

Amazing trick!!! Subscribed!

@DougHExcel 3 жыл бұрын

Thanks for the sub!

@raminashtari6719 2 жыл бұрын

That's really helpful, thanks 😊

@DougHExcel 2 жыл бұрын

Glad it was helpful!

@MrBmic 4 жыл бұрын

Good stuff. I am going to use this to randomly select the draft order for my fantasy football league. Thanks.

@DougHExcel 4 жыл бұрын

Good luck!

@OzduSoleilDATA 5 жыл бұрын

Very nice!

@DougHExcel 5 жыл бұрын

Thanks Oz!

@mornalassar9192 4 жыл бұрын

Thank you thank you THANK UU

@DougHExcel 4 жыл бұрын

You're Welcome!

@JCEurovisionFan1996 2 жыл бұрын

Good one, Doug. You could also use the XLOOKUP function.

@DougHExcel 2 жыл бұрын

Hi John Christian, thanks for the comment! Absolutely XLOOKUP is a great alternative!

@prakashd3228 4 жыл бұрын

Nice to you

@DougHExcel 4 жыл бұрын

Sorry, don’t understand the comment/ question...

@prajaypawar19 2 жыл бұрын

great video

@DougHExcel 2 жыл бұрын

Thanks!

@rubelhasan968 4 жыл бұрын

very nice

@DougHExcel 4 жыл бұрын

Thanks Rubel Hasan!

@MTJ1 3 жыл бұрын

Gud explained

@DougHExcel 3 жыл бұрын

Hi Hassan Khan, thanks for the comment!

@gamer95z41 4 ай бұрын

Can you tell me how to get random names based on weighted probability such as the number of raffle tickets holding?

@monkeyman998. 4 жыл бұрын

Am a div,but like to see your vid,great work,hopefully one day my brain will get it right...

@DougHExcel 4 жыл бұрын

You can do it!

@monkeyman998. 4 жыл бұрын

just trying now,going is slow,lol...

@monkeyman998. 4 жыл бұрын

Lol,i did say am a div,took all this time for me to see and hear that its a $ not a S.What a div i am...

@lilianchr 3 жыл бұрын

Super guide, is there a limit to the numbers on names you can have on the list?

@DougHExcel 3 жыл бұрын

Hi lilianchr, thanks for the comment! In term of limits, not that I know of

@joegurto 2 жыл бұрын

How can I generate the second and subsequent sets of names and exclude certain ones each time?

@DougHExcel 2 жыл бұрын

one of these might help kzfaq.info/sun/PL-n8f1cY_Qw8iJkY0bCyYxXijfeYIwbcd

@JCEurovisionFan1996 2 жыл бұрын

To answer your question, you have to use the XLOOKUP function, where you look at the given value and select the lookup array for that value, then you ask to give the return array for that value.

@misskiki315 3 жыл бұрын

By doing this, will the same name generate again? I have a group of 105 people that I need to split up into groups of 5.

@DougHExcel 3 жыл бұрын

It should not unless that source list have same name in multiple rows.

@pequodexpress 3 жыл бұрын

What would I need to do to go through the list selecting one name at random each time but be able to go through the entire list once without repeating a name?

@DougHExcel 3 жыл бұрын

maybe one of these could help kzfaq.info/get/bejne/kMWSZsyEqsjapHU.html

@nandoflor 3 жыл бұрын

Hey, any chance you can help me out? so here's the problem, I have a list with 600 workers names (column A - worker number, column B worker name, column C worker area). My objective is to create an excel where I can randomly select 10 workers of that list. After the draw I want to keep a historic of it, and for the next draw eliminate the names that already came out on the first draw. Thanks a lot, much appreciated!

@DougHExcel 3 жыл бұрын

One of these in the playlist might give an idea kzfaq.info/get/bejne/bJ6gjZOm17Oqm4U.html

@nandoflor 3 жыл бұрын

@@DougHExcel I've seen them all and still haven't figured it out! Anyway thanks, all the best from Portugal!

@powerdriller4124 3 жыл бұрын

Shuffle the 600 of them as shown in this video, making so a list of 600 non repeated ones. Then take the first ten in the list as the first group, the next ten as the 2nd and so on..