How to generate a Random List in Excel

A video on how to generate a random list in Microsoft Excel using a combination of the RANDBETWEEN function and the VLOOKUP function.

[howitsbeen]

Thank you! I'm ready for my test! :D

[lfratice]

Thank you so much this really helped me out!

[trentwakelin]

worked great for me. Thank you very much

[jessicagreene]

Thanks! This is exactly what I wanted to do.

[VirusDeployed]

is it possible to not get the same number twice?

[rthoodi]

Nice Information, it helped me alot, Thank you

[papaboobee]

Thank you so much, that help me a lot of time

[nofsnew]

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?

[muhannadghazal]

It worked perfectly for me, thanks man.

[bassieboy]

thanks, it was very helpfull for me and my friend

[rfcesq]

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])))

[chaosunstabledynamic]

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

[bobbie]

what do you mean by 'fix it with a full'?

[eugenedawson]

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?

[ayaalsharafi]

How did you record your screen? I really need to know ;(

[andreapickerill]

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?

[kevinsue]

hi can you make a random list of lets say 100 names in groups of 10, so every possible option of names put together?

[njoyce]

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

[jillamos]

what does "fix it with a four" after the Vlookup mean?  is it supposed to say F4? 

[clintdvo]

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.