Скачать с ютуб Excel - A Better Lotto: Episode 1401 в хорошем качестве

Excel - A Better Lotto: Episode 1401

Microsoft Excel Tutorial: Learn Excel: How to Pick Lotto Numbers Without Duplicates (Alternative Method). Welcome to another episode of the MrExcel podcast, sponsored by PowerPivot. Make sure to visit facebook.com/powerpivot and take the NERD-TASTIC QUIZ for a chance to win an Xbox 360. In today's episode, we will be discussing a common issue faced by many Excel users - how to pick lotto numbers without getting duplicates. This question was sent in by Warren from Australia, and we will be exploring a better solution to this problem. Warren's initial approach was to use the RANDBETWEEN function, but he noticed that he would eventually run into duplicates if he pressed F9 enough times. He believed this to be a bug in the function, but in reality, it is just the way RANDBETWEEN works. So, if you want to avoid duplicates altogether, I have a different method that you can try. Let's take a look at this big, complex formula that I have here. Don't worry, we will break it down step by step. First, I use the =RAND function and copy it down 45 times, as Warren is picking numbers from 1 to 45. Then, we have the large formula, which is similar to the MAX function. However, instead of just getting the largest value, we can specify which largest value we want. In this case, we are asking for the second largest value, then the third, and so on. Next, we have the MATCH function, which is looking for the value we got from the large formula in the range of random numbers. This will tell us where that value occurs, and we can use that to get our final set of numbers. By combining these three functions, we can ensure that our lotto numbers are unique and will rarely repeat. Of course, there is always a chance that one of the random numbers may occur twice, but with such a large range of precision, it is highly unlikely. This method is much more reliable than using RANDBETWEEN, as Warren had initially tried. Thank you for tuning in to this episode of the MrExcel podcast. I hope this solution helps you pick your lotto numbers with ease. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... Table of Contents: (00:00) Better Lotto (00:19) Using RANDBETWEEN for lotto numbers but avoid duplicate numbers (00:30) Explanation of RANDBETWEEN function (00:40) Alternative method to avoid duplicates (01:12) Explanation of formula components (01:26) Example of formula in action (02:24) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Better Lotto Duplicate numbers Episode 1401 Facebook.com/powerpivot Formula breakdown Learn Excel Lotto number picking NERD-TASTIC QUIZ PowerPivot RANDBETWEEN Xbox 360 Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads... Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates. "Learn Excel"