Task: Find The Most Common Lottery Numbers
This dataset contains the ACTUAL winning lottery numbers from 2010 to 2023. Use your skills at Microsoft Excel to find the 6 most frequent numbers. Please note that you can't just do a pivot table to solve this. You will need to use TEXT TO COLUMNS and then reformat the worksheet to solve this (eventually) with a pivot table. If you do this right, you might as well buy a lottery ticket.