How to Create Random Numbers in Excel (including no repeats)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this video I'll show you how you can easily create sample data in Microsoft Excel. Generating Random data is often needed for testing or if you need to share a file with someone who shouldn't see your actual data. I'll cover different methods to create random numbers including a solution that creates random data without repeats.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/random-numb...
Here's what you'll learn:
Basic to Advanced Techniques: From simple random decimal numbers to complex non-repeating integer lists, this video covers a range of methods suitable for various needs.
Using RAND Function: Discover how to use the RAND function to create random decimal numbers between 0 and 1, and learn tips to prevent them from recalculating.
RANDBETWEEN for Specific Ranges: Learn how to use the RANDBETWEEN function for generating random integers within a specific range, and how to convert them into decimal numbers.
RANDARRAY Function in Office 365: Explore the RANDARRAY function available in Office 365 and Excel on the web for generating multiple rows and columns of random numbers.
Unique Function for No Repeats: Combine RANDARRAY with the UNIQUE function to ensure your random numbers don't repeat, understanding how to manage potential errors.
Sequence and Sort By for Random Order: Learn how to use the SEQUENCE and SORT BY functions to create non-repeating, randomly ordered numbers without resizing issues.
Non-Office 365 Solution: Discover an alternative method using the RAND function and custom sorting for those not using Office 365.
00:00 How to Generate Random Numbers in Excel
00:29 How to Use the RAND Function
01:15 How to Use the RANDBETWEEN Function
02:05 How to Use the RANDARRAY Function
02:59 How to Create Random Numbers WITHOUT Repeats
04:11 Use Sequence function to get Avoid Repeats & errors
05:54 Non Office 365 Solution to Avoid Repeats
06:44 Wrap Up
LINKS to more Excel videos: • Excel Advanced Formula...
★ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Пікірлер: 222
Grab the file I used in the video from here 👉 pages.xelplus.com/random-number-generator-file
Le rythme, les explications tout est parfait. C’est la première fois que je planche sur Excel à cette heure de la nuit sans m’endormir !!!! Bravo.
Your tutorials are totally worthwhile. I don't know if I will ever need this, but this video is so memorable that I will recall it if and when the need arises..!
This is so convenient. Thank you so much for putting all these in one place, you rock!
Your lessons are amazing! I totally love it. The explanations , presentation, content everything is on point!💯
@LeilaGharani
3 жыл бұрын
Thank you! I appreciate that!
Hey! Many thanks once more! Always with super accurate and straight forward examples!! Keep going the good work :)
Many thanks for the clear explanation, Leila!
You are the greatest, Leila. I had not thought of using unique with randarray yet.
Hi Leila I have been following you for about 18 months thank you so much for taking my Excel knowledge to the next level
Wonderful info, Leila. I was scratching walls to create vba or macro in order to refresh the numbers, but your F9 method which I just tried on my random number generator works perfectly! It made my life a lot easier, and besides you teach a lot of some other important excel tricks. Thank you very much . . . .
@LeilaGharani
Жыл бұрын
Glad it was helpful!
Just what I was looking for…perfect timing thank you so much.
Nice to see that I am not the only one who is still learning, I would love for you to do a "simple😂😂" googlemaps type route/distance calculator between two business locations. Love your channel.
Cool, Leila!!! Thanks! That was one I needed 😀👍👍👍
Love it, thanks Leila!
Thank you, Leila for all of these amazing tutorials. They are very much appreciated! :)
@LeilaGharani
3 жыл бұрын
Glad you like them, Dave!
... FELICITACIONES x TUS VIDEOS!! CONGRATULATIONS FOR YOUR VIDEOS !! ERES UN EJEMPLO A SEGUIR!! YOU ARE AN EXAMPLE TO FOLLOW !!
Good job Liela, good job 👌🏽 Never regret watching your videos, the topic seems familiar to me, all functions you mentioned are well known to me and I'm using them frequently, but yet I opened the video! Not surprisingly, I found something new and interesting too! Looking forward to that one day for me opening your videos and learn nothing, I guess I will spend a lot of time until then!
@LeilaGharani
3 жыл бұрын
Happy to hear you found something new!
Thanx a lot mam,I found solution to one of my problem I was stuck in since long from your this video. Thanx a lot
This is the best explanation I have seen on the rand function so far...Thanks a lot!
@LeilaGharani
7 ай бұрын
Glad it was helpful!
I learned a lot about rand function. I love you.
Thank you Leila. Finally! A useful formula to help me pick the random winning Powerball numbers 😁
Great tutorial as always. Thanks for sharing
Great one again, Leila!
thank you SOOOO much! I needed this for my experimental design and it worked perfectly!
So happy with this. I saved this one 👍🏻. Thank you!!
Thank you. I needed this for tutoring kids for time tables. This is truly amazing. So simple buy I didn't know how until I saw this. Lovely lady you are. :)
Mam your teachings are very helpful. Thanks a load for your effort.
Really handy tips 😉 I was looking for that for a while 🤗 thank you Leila
@LeilaGharani
3 жыл бұрын
You’re welcome 😊
Great as Always --- as a part time Bingo caller I can see my spreadheet random number generator changing in the near future
THANK YOU DEAR LEILA JAN, YOU ARE HELPFUL AND AWESOME LECTURER.
I'm making my own Number Sense practice sheets, and the Google searches I've seen explain these functions so poorly; this video was a lifesaver
Thanks Leila. Solved my problem as always
Handy tips as always Leila, very intuitive, thanks for sharing
@LeilaGharani
3 жыл бұрын
My pleasure, Darren!
Just simply awesome 👍
Thank you! You are very talented and easy to understand!
@LeilaGharani
Жыл бұрын
Wow, thank you!
Cute technique. Thanks for sharing ☺️
Hmmm, just when I think I know enough of a feature in Excel, Leila ensures that I don't and what a boon it is really! Thanks again Leila for showing what is possible with random numbers! Nice video! 😊👍
@LeilaGharani
3 жыл бұрын
Glad you found something new, Vijay!
Cool! That'll definitely be helpful! 😃
Great video. This has helped me, along with a lookup formula, to create a random staff rota.
@LeilaGharani
Жыл бұрын
Glad it was helpful!
You are the best in this field. Thank you for sharing the knowledge and working so hard to present it excellently. Everything is so smoothly presented precise, concise and on point.
@LeilaGharani
4 ай бұрын
Wow, thank you!
This is randomly awesome 😆
You are awesome. You have really helped me a lot I am impressed how these small changes can now help me with my data
@LeilaGharani
3 жыл бұрын
Great to hear!
Thanks for the "random" video full of neat surprises!
Thank you! :)
Thank you so much 💓
Thank you so very much. This was a great video!!!
@LeilaGharani
3 жыл бұрын
Glad you enjoyed it, Daryl!
Wow... Very nice explain.
Nice Video!!
Leila, your video is amazing. Thanks so much. Can you explain how to make a sort number by group of columns (example: by area)
A Great technique. Now I understand the entire content properly. Thanks once again Madam. May I also request you to please upload the video regarding creation of random letterrs and A TO Z alphabets.
Amazing as always
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
Fantastic tric Thank you so much Mam God bless you with your fmly
thank you so much
Hi Leila, honestly, I never knew about how powerful Excel is and your channel helped me realized that. I have one question tho, I have to ask the professional. How did you create that animation at 0:23?
@LeilaGharani
3 жыл бұрын
That's prepared with Premier Pro and After Effects.
Awesome 👍
Thank you
You are the reason why I don't rank my Excel skills as a 10 out of 10. Thank you 🙂
@LeilaGharani
3 жыл бұрын
😁
@cheesepun
2 жыл бұрын
even she's learning
Superb 👌
Very useful while making roster for team..
VERY NICE 👍👍
Hi Lelia, Thanks for showing awesome Excel capabilities. Wondering any suggestion for generating predictive number based on historical data; say for example if i have set actual data of past 100 outcome of coin toss? Any statistical function in Excel 365 is available? Thanks in advance JM
Thank you mam..
So cool and useful in randomly choosing next weeks Powerball numbers 🔮 🎰 💰
Thanks excellent tutorial
@LeilaGharani
3 жыл бұрын
Glad you liked it.
Thanks
Thank you for your perfect explanation, in case I need to select the value randomly but just for many specific values I would specify them taking the percentage of repeated values that I will define, into account, what can I do? thank you
It much helpfull
The one of excel expert
Once again you have proved that I have a lot more to learn with Excel!
@LeilaGharani
3 жыл бұрын
There's always more to learn :)
@sandeeppeddi7075
3 жыл бұрын
@@LeilaGharani this makes me more happier 😀
we have now google sheets and the excel web app. a comparison would be fine... maybe in more than just one vid. there is surely something google sheets can, and excel can't... and ofc vice versa. that would be a cool topic, if you are searching for some future topics 😁👍 thank's anyway for your work
you are amazing
Added to my list of Excel Wizardry.
Cool... I now know how to generate Random Numbers without repeats! THanks! 🙂
@LeilaGharani
3 ай бұрын
Glad it helped!
Great and sweet…!!!
Good video :) Any nice tips for random names as well ?
Genius!
Good Evening Ma'am, Thanks for all the information. Your videos continue to be great sources of knowledge for the multitudes. I have a quick question pertaining to the number ranges. Can you set the randbetween to only select whole numbers by tens or hundreds or thousands? [randbetween(100,900)] where it will only pick 100, 200, 300 ,400,ect randomly? I'm trying to make a homework generator for my daughter using similar problems that she sees in class, without having to randomly type out everything for each day. Thank you!
🌹🌹💜thanks miss
Hi Leila, you are amazing! Every day I learn something new from you. I need help extracting a random unique list from an existing list. My list has three columns. The first column contains names, the second column contains a case number, the third contains a resolution number. The names repeat (i.e. a name has various case and resolution numbers assigned to it). How can I extract a random list for unique names only? Thank you.
Interesting & well explained !! Can you share how to put random dates ?
@magnushultgrenhtc
3 жыл бұрын
Dates are numbers. For clarity, you can set a lower and upper limit in separate cells and refer to those cells. Just remember to format the outcome as a date.
Leila, Thanks for the videos, appreciated very⁹ much!! How do I go about with a list of names say for team peer to peer review. The output needed is a list of "Peer to Review" from team list, Noting that ; a. You can't review yourself and, b. Each member has to participate. Thanks in advance.
Do you have plans to do a Power Automate Desktop course?
Wow what a fantastic way to accomplish that. Keep on sharing this with us. Love from #khushvibes channel
Rand() function works randomising values from a uniform distribution. But what about getting random numbers from another kind of distribution - normal, Poisson, etc?
Hi Leila, I am using a combination of CHAR and RANDBETWEEN functions to generate a random password of 10 character starting with Capital and a mixture of Alphanumeric and special characters but whenever the spreadsheet refreshes it changes the values and I like to keep the values. =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(35,38))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(60,63))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(101,989)
Thanks. Please show how to select random work orders and value of data. Please. Thanks
I have Office 365 and noticed that random number generator, which I created years ago, no longer recalculates when I depress F9. Through some experimenting on the keyboard, that the Function key + F9 now recalculates my 60 fields for random numbers. Just and FYI. Thanks for your videos.
Hi Thanks for easy to understand video Can you tell me how I can creat 5 digit random numbers between 10 to 30
Hi Leila..Please explain how to write Macros for csv formatted files.. Thank you.
Hebat
Hi... Plz guide how to concatenate two cells by keeping the text color format?
Hi Leila.. would you suggest for data analysis which is better.. MAC or Windows..
Can you do a video on best practices for storing important emails outside of outlook? The company i work for rolls emails off after 90 days. Projects I work on can last all year and email has lots of history in it related to projects that I sometimes need to reference....like proof of project decisions made. How do you extract important emails? What are best practices for organizing and storing them so I can find them long after that 90 day retention threshold is hit. Thanks.
Hi mam Your all lessons are amazing. I have a question that is 10000 is my total sale. I want to convert this value into 15 days but without repeating. Pls suggest which formula will apply.
Thank you for your explanation But for sure Randbetween function makes repeated number I am positive you know that Could we somehow make it with out repetition I found some salutions but they are sort of compelecated
Hi Leila, This is a great tool but my version of Excel does not have the "=unique(randarray", "=rand(array) or "=sequence" functions. is there another way to use those functions? Thanks so much
Great for Monte Carlo simulations.
This is great, how can do I a random sequence for say 24 rows but within those rows are random numbers from 1 to 36 ?
Leila- I have a list of 10 companies and each company has 5 or more contacts. I wish to assign the same number to the first contact of each company. For example- Assign #1 to the first contact of each company. Assign #2 to the second contact of each company. So on and so forth for the rest of contacts
Can I use Randbetween with unique to get non repetitive numbers?