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

2 Просмотры
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.

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

★★★ My Online Excel Courses ►

⯆ DOWNLOAD the workbook here:

LINKS to more Excel videos:

★ Get the Official XelPlus MERCH:

✉ Not sure which of my Excel courses fits best for you? Take the quiz:


GEAR I use: #gear

More resources on my Amazon page:

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!

Приколы 2020 года смех до слёз
Комментариев нет.