Generate a Unique List of Random Numbers in Excel With a Simple Formula

Опубликовано: 29 Сентябрь 2024
на канале: TeachExcel

17,923

156

Create a list of unique random numbers in Excel with a simple formula that is easy to use and change - this works in older versions of Excel as well as Excel 365.

Excel File: https://www.teachexcel.com/excel-tuto...
Excel Forum: https://www.teachexcel.com/talk/micro...

In this tutorial I show you 4 different formulas for generating unique lists of random numbers in Excel - this includes simple methods and more complex methods that allow you to set the minimum and maximum possible values as well as simple methods for simple lists that just need to appear in random order.

Everything in this tutorial should work for Excel versions back to 2007, or at least 2010, but let me know in the comments if you run into any issues.

As usual, make sure to download the file for this tutorial so you can follow along or just copy/paste the formula and use it as you want.

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course...
- Building Professional Forms: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #howto #tutorial