Generate a Unique List of Random Numbers in Excel With a Simple Formula
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
Watch video Generate a Unique List of Random Numbers in Excel With a Simple Formula online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 26 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17,923 once and liked it 156 people.