Lotto Probability – 454 – Learn Excel from MrExcel Podcast

Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast.Episode 454 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

goo.gl – Using a spreadsheet to analyse lottery number statistics and frequencies