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

[@DougHExcel]

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

[@DougHExcel]

...

[@primahadi_wijaya]

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

[@DougHExcel]

Awesome! Thank you!

[@danaaustinspeaks6730]

You are a great, event paced teacher!

[@DougHExcel]

Thank you! 😃

[@anniepike5892]

F9 key not doing any changes on my excel 365, any suggestions

[@DougHExcel]

try the delete key in an empty cell

[@LaRedCR]

Amazing trick!!! Subscribed!

[@DougHExcel]

Thanks for the sub!

[@joegurto]

Thank you. Just what I was looking for.

[@DougHExcel]

Glad I could help!

[@JCEurovisionFan1996]

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

[@DougHExcel]

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

[@raminashtari6719]

That's really helpful, thanks 😊

[@DougHExcel]

Glad it was helpful!

[@MrBmic]

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

[@DougHExcel]

Good luck!

[@gamer95z41]

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

[@Dauda100]

Learned alots from you Doug.

[@DougHExcel]

Thanks!

[@Luciano_mp]

Good tip, Thanks Doug!

[@DougHExcel]

You're Welcome!

[@lilianchr]

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

[@DougHExcel]

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

[@joegurto]

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

[@DougHExcel]

one of these might help kzbin.info/aero/PL-n8f1cY_Qw8iJkY0bCyYxXijfeYIwbcd

[@JCEurovisionFan1996]

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.

[@johnclarke1319]

thanks, clear as mud

[@DougHExcel]

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

[@prajaypawar19]

great video

[@DougHExcel]

Thanks!

[@ZAHIDHUSSAIN-ri5kg]

Many, many thanks Doug!

[@DougHExcel]

You're Welcome!

[@MTJ1]

Gud explained

[@DougHExcel]

Hi Hassan Khan, thanks for the comment!

[@OzduSoleilDATA]

Very nice!

[@DougHExcel]

Thanks Oz!

[@Paul998-B]

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

[@DougHExcel]

You can do it!

[@Paul998-B]

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

[@Paul998-B]

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...

[@misskiki315]

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]

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

[@nandoflor]

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]

One of these in the playlist might give an idea kzbin.info/www/bejne/bGnTi2Orp7J5obM

[@nandoflor]

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

[@powerdriller4124]

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..

[@pequodexpress]

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]

maybe one of these could help kzbin.info/www/bejne/kJDFZJyJesepqqM

[@rubelhasan968]

very nice

[@DougHExcel]

Thanks Rubel Hasan!

[@2056ash]

how to add a button in excel with hyperlink of F9 to get the result by just clicking that button and not function key F9.

[@DougHExcel]

An option is the record a macro and then attach the vba code from it to a button

[@2056ash]

@@DougHExcel is there any video for the same?

[@mornalassar9192]

Thank you thank you THANK UU

[@DougHExcel]

You're Welcome!

[@prakashd3228]

Nice to you

[@DougHExcel]

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

[@ashleyluna2626]

6:13 David Luna is my dad's name

[@DougHExcel]

😀