Create a List of Random Numbers without Repeats

Here's a video that will show you how to create a list of random numbers that don't repeat. I'm sure there are many other uses for this trick, but the only one I can think up now is if you didn't want to rely on a lottery machine to perform the quick pick. Aside from getting your own lottery balls, throwing them around and picking up the "lucky" numbers, Excel can also let you create your own quick pick random numbers.


📝 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!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[F_A_R_man]

Here easy way:
In A column just fill series between 1 and what you want, for exp. 10000 . Then in B column type =RAND() and let it till the end of A column. And then sort B column from small to large or vice verse and expand selection in option window that will appear. And you`ll get randomly sorted and none repeated nums between 1 and 10000 in A column. Delete column B.

[HallMade]

This was the best! Exactly what I needed! Thanks heaps bro, From Australia

[mkrntn]

This is great!

My method was to create a macro to copy rand value onto another column, then rank and sort it accordingly.

Gotta try this tomorrow, thanks a lot

[kajskoglund]

On a laptop.. fn+f4 not just f4, also ; instead of, for some versions of excel.

Espectacular y sencillo.... muy útil. Muchas gracias Doug - Thanks a lot Doug!

[SyafiqZaidi]

Thanks, brother. Now I can generate random number for my board games. Splendid!

[yelj]

How do you sort them from low to high? But also react to the other sequences, that it will know what kind of sequence it will have the next time?

[raghudas]

Total how many random numbers qe can do from 1 to 52 with our duplicate

[mark]

This does not work when using whole numbers (I tried it), as I get duplicates.

[excelisfun]

That is a really cool trick - I may have to teach this in my Stats Class : ) Thanks, Teammate!

[raghudas]

How many random numbers we can select from 1 to 52 numbers with out duplicate please advise

[barttitulaerexcelbart]

Cool trick thank you. there are plenty of cases where this is useful, for example select 5 volunteers from a group of 10.

[MrSunshanmu]

HI thanks man this is an awesome tutorial. I was wondering if I had two bonus numbers how would I go about that? thanks in advance

[Jmaxxx]

Great Vid. Is there any way to have the random generator generate with a button press instead of pressing F9, doing it for football squares.

[shubhammathur]

This is really cool! Is there a shortcut to not change the k value for each cell? dragging the fill handle doesn't do the trick. What method could we use to generate 200 random numbers without repeat?

[Dogflamingo]

Thank you very much, this was very helpful. It worked perfectly in google sheets, but it's a shame F9 doesn't refresh

[jackparker]

Works great. How about if my numbers in my box have to be a 2 digit number. I want to eliminate any single digits. I tried generation my random number list starting with row 10 but it still listed single digit numbers.

[houarian]

want to to know ho to select the Nth row ie D5:P5 where N is a random number in column A

[davidharris]

Doug is it possible to have 6 rows of start and end times that are generated randomly but add up to whatever total is chosen say a start at 7 am and Excell fills in the start and end time for each of 6 rows to meet a given time of 8 or whatever total hours is chosen without repeats over 30 rows?

[ayizeakono]

Hey Doug...nice trick....why didn't u use columns as the 'k' argument for large though, instead of hard-coding the numbers?