How to Create Random Numbers in Excel (including no repeats)

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.

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

🚩Let’s connect on social:

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

[erynchapman]

thank you literally no one else could explain it but you

[jeanlucfcn]

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.

[advaitpetiwale]

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

[Stef]

Once again you have proved that I have a lot more to learn with Excel!

[trik]

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

[mochi]

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

[markdavies]

Hi Leila I have been following you for about 18 months thank you so much for taking my Excel knowledge to the next level

[kolavithonduraski]

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

[FVG-]

This is the best explanation I have seen on the rand function so far...Thanks a lot!

[calevenice]

You are the reason why I don't rank my Excel skills as a 10 out of 10. Thank you 🙂

[Armstrong_N]

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.

[serdalkaptan]

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

[soumitratewari]

Mam your teachings are very helpful. Thanks a load for your effort.

[ibrahimismayilov]

Many thanks for the clear explanation, Leila!

[ntahir]

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

[amrabilalovic]

This is so convenient. Thank you so much for putting all these in one place, you rock!

[IzharHazelEspinozaCastillo]

...
FELICITACIONES x TUS VIDEOS!!
CONGRATULATIONS FOR YOUR VIDEOS !!

ERES UN EJEMPLO A SEGUIR!!
YOU ARE AN EXAMPLE TO FOLLOW !!

[nijapillai]

Your lessons are amazing! I totally love it. The explanations, presentation, content everything is on point!💯

[rajeevgosavi]

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.

[MrBradleykeith]

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.