www.xlninja.com... A video on how to generate a random list in Microsoft Excel using a combination of the RANDBETWEEN function and the VLOOKUP function.
I found the answer by searching for "How to create a list of random unique numbers in excel" on google. Really useful website from a site called, "Get digital help".
Easier way to do this is with Index and tables. I used a table named "tblData" with a column that had several names in it (i.e. column header = "Name"). This formula did all the work to give me random names. =INDEX(tblDate[Name],RANDBETWEEN(1,ROWS(tblData[Name])))
Thanks Aldo! Question, Is there anyway to set this as a macro in a button? I would like to be able to click the button and have excel select a random value from the list, and add it to a new list. I would like to add a new random value to the new list, each time i click the button. Is this possible?
I wanted to create a random roster that eliminates that selection for the next day. Is that possible. Also are parameters like those adjustable for specific individuals?
he means, when the code is like for example =vlookup(A4;D4;E30 you change is with a dollar sign by pressing shift 4 making =vlookup(A4;$D$4;$E$30 and go to the next step
I followed exactly the same procedure step by step, I even used the same example and it didn't work. I wanted to create a random list or a random sequence of samples to use in a Measurement System Analysis, but it didn't work. :(
Thanks for sharing this. What if I would like to randomize a calender. I'll be experimenting if I don't come back it would mean I haven't gotten the answer.
Sometimes it varies in different languages. F.e. in my version rand function is changed to los (as "rand" is from english "random" and "los" is from polish "losowy")
is it possible to not get the same number twice?
what do you mean by 'fix it with a full'?
I found the answer by searching for "How to create a list of random unique numbers in excel" on google. Really useful website from a site called, "Get digital help".
Easier way to do this is with Index and tables.
I used a table named "tblData" with a column that had several names in it (i.e. column header = "Name"). This formula did all the work to give me random names.
=INDEX(tblDate[Name],RANDBETWEEN(1,ROWS(tblData[Name])))
Thank you so much, that help me a lot of time
thanks, it was very helpfull for me and my friend
Thanks Aldo!
Question, Is there anyway to set this as a macro in a button? I would like to be able to click the button and have excel select a random value from the list, and add it to a new list. I would like to add a new random value to the new list, each time i click the button. Is this possible?
Thank you sir.. 😊
Thanks! This is exactly what I wanted to do.
Very nice 👌👍!!
Thank you! I'm ready for my test! :D
Nice Information, it helped me alot, Thank you
2:25 what does it mean by fix it with a full?????
worked great for me. Thank you very much
I can get clear to the copy and paste step. Once I copy it paste the same students name and number all the way down the list. What am I doing wrong?
I get multiples of the same numbers and names! Why?
Thank you so much this really helped me out!
THANK YOU ALDO!
I wanted to create a random roster that eliminates that selection for the next day. Is that possible. Also are parameters like those adjustable for specific individuals?
Thanks for the handy video :)
thank you, sir
what does "fix it with a four" after the Vlookup mean? is it supposed to say F4?
he means, when the code is like for example
=vlookup(A4;D4;E30
you change is with a dollar sign by pressing shift 4 making
=vlookup(A4;$D$4;$E$30
and go to the next step
good. ..very good.
hi can you make a random list of lets say 100 names in groups of 10, so every possible option of names put together?
It worked perfectly for me, thanks man.
Hey buddy worked
very helpful....
I followed exactly the same procedure step by step, I even used the same example and it didn't work. I wanted to create a random list or a random sequence of samples to use in a Measurement System Analysis, but it didn't work. :(
Thanks for sharing this. What if I would like to randomize a calender. I'll be experimenting if I don't come back it would mean I haven't gotten the answer.
Dates are integer numbers - so use "randbetween" function for the start and end dates required - then format cells to date format
It is simpler than that?
If your names are in A1 to A5 you can use the following formula in B1 and drag it down.
=INDEX($A$1:$A$5,RANDBETWEEN(1,5))
Cool tip.
how can we perform 50% random selection from total of 100 names?
I had the same question!
Thank you!
How did you record your screen? I really need to know ;(
why can't they just make a button for it like in google sheets
it didn't work for me
=RANDBETWEEN(1;6)
this won't work for me, help!
Sometimes it varies in different languages. F.e. in my version rand function is changed to los (as "rand" is from english "random" and "los" is from polish "losowy")
And then you fix it with a 4 ?????????????????????
F4
@@aangitano Omg thank you, I've been trying to figure out what the hell he said for an hour...
You were talking to slow, please increase a bit higher.