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.
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!
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..
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?
For more videos that cover random number or value generation see ua-cam.com/play/PL-n8f1cY_Qw_FyrtQzHiqktUC6PuqEzQE.html
...
That “flash fill” thing is a star!! I always use the concatenate function in that situation! Really glad to find your video, Doug.
Awesome! Thank you!
You are a great, event paced teacher!
Thank you! 😃
Good one, Doug. You could also use the XLOOKUP function.
Hi John Christian, thanks for the comment! Absolutely XLOOKUP is a great alternative!
F9 key not doing any changes on my excel 365, any suggestions
try the delete key in an empty cell
thanks, clear as mud
John Clarke, that is very interesting...thanks for letting me know.
Can you tell me how to get random names based on weighted probability such as the number of raffle tickets holding?
Amazing trick!!! Subscribed!
Thanks for the sub!
Thank you. Just what I was looking for.
Glad I could help!
Good stuff. I am going to use this to randomly select the draft order for my fantasy football league. Thanks.
Good luck!
Super guide, is there a limit to the numbers on names you can have on the list?
Hi lilianchr, thanks for the comment! In term of limits, not that I know of
How can I generate the second and subsequent sets of names and exclude certain ones each time?
one of these might help ua-cam.com/play/PL-n8f1cY_Qw8iJkY0bCyYxXijfeYIwbcd.html
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.
That's really helpful, thanks 😊
Glad it was helpful!
great video
Thanks!
Learned alots from you Doug.
Thanks!
Good tip, Thanks Doug!
You're Welcome!
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.
It should not unless that source list have same name in multiple rows.
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!
One of these in the playlist might give an idea ua-cam.com/video/68pZ0urMFkQ/v-deo.html
@@DougHExcel I've seen them all and still haven't figured it out! Anyway thanks, all the best from Portugal!
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..
Many, many thanks Doug!
You're Welcome!
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.
An option is the record a macro and then attach the vba code from it to a button
@@DougHExcel is there any video for the same?
Gud explained
Hi Hassan Khan, thanks for the comment!
very nice
Thanks Rubel Hasan!
Am a div,but like to see your vid,great work,hopefully one day my brain will get it right...
You can do it!
just trying now,going is slow,lol...
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...
Very nice!
Thanks Oz!
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?
maybe one of these could help ua-cam.com/video/Z_b3iSEbvtA/v-deo.html
Thank you thank you THANK UU
You're Welcome!
Nice to you
Sorry, don’t understand the comment/ question...
6:13 David Luna is my dad's name
😀