Unique Number Generator: How to Create Non-Repeating Random Numbers

Discover how to create non-repeating random numbers in Excel in today's tutorial! This video is perfect for anyone looking to generate a clean, unique sequence of numbers for use in simulations, games, or random draws. We'll cover essential Excel functions and formulas that ensure no duplicates, providing you a reliable way to handle your data. Follow along as we break down the steps clearly, showing you exactly how to set up your spreadsheet for success. By the end of this video, you'll be equipped to use these techniques in your own projects with confidence. This video covers how to generate random numbers that don't repeat. Got this solution from mrexcel forum, tested it out and wanted to share.

📝 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"
-~-~~-~~~-~~-~-

[andycobraaor]

Mr. Doug;

great class, you are a great professor and knows how to explain the formula, thanks.

Respectfully;
Andy

[andycobraaor]

Sir;

Great job, thanks I am working on one like your example but for the Lottery number game, thanks.

Respectfully;
Andy

[AszRox]

This is great Doug H...how do i add to the formula...I need it the above to include only odd number and add up the sum of the 6 random number to be 158??

[alirezagh.]

All this random generating choose numbers starting from 1 to 50 or 100 or whatever in order. What if you want to pick the numbers out of the customized numbers not in order. For example if you want to pick 5 numbers out of 1 to 10, 21 to 30 & 41 to 50 (not 11 to 20 & not 31 to 40) . I couldn't find solution for that...

[andycobraaor]

Mr. doug;

thanks for your insights education, I will really appreciated, I'm sure that you are about to laugh but I was looking for a formula that explain me the none repeating number when I make calculation with the RAND formula because of the Lotto Game that I am looking forward to win the lotto if ever I got luck. Anyways, thanks for the great educational videos.

Respectfully;
Andy

[fittness]

Strange, I followed the vid ALL the way through (I didn't stop when #NUM appeared, ) and it works fine. Didn't get a repeated number once (in 4 solid minutes of generating new numbers) and haven't seen #NUM since adding the range of numbers from A1:A100. It does work.

[grouchysmurf]

Can this formula be tweaked into generating actual words not just letters, which you've mentioned somewhere in the comments? Instead of numbers, let's say 5 different names to be generated randomly from a list of 10 names. Also the percentage of each data is different... that it is more likely a higher chance for some to get picked than others.

[subashish.khanka]

what if i want to use text instead of number then which formula can be used?

[ajpran]

hii, it's only 3 Rows, how to make it 10 columns in every rows ?
thanks.

[lynnlee]

how do i set a template for no repeat if i don't know the Max. number beforehand?

[gnng]

Q1: Generate an array of number 1 to 200 by using For-loop, then display on a Graph Indicator.
answer please

[jkromes]

I have a list of 150 randomly generated numbers from 1-800. How do i create a second batch of 150 without any repeats from first list?

[sunilbishowkarma]

in this formulas how to exclude some of number ???

[nobodybutyou]

Unreliable. Still got same number and sometimes gets you NUM! error

[MarkNorville]

This method is useless for a lot of numbers if you wanted to generate 5 or 6 numbers you would have a formula longer than your arm. The chances of randomizing between 1 and 100 and getting a repeat just using 3 is very slim.