409343 Lottery Excel Worksheet

I need a spread sheet to help find the number of times that a lottery number and mega ball number have been picked over a 20-1000 drawings. This can be done with an excel spreadsheet. How the game is played: For each wager, we select five numbers from a pool of 1 to 56 and one Mega Ball number from a second pool of numbers from 1 to 46. I want to enter into the spreadsheet say the last 20 sets of winning lottery numbers which can be found here [login to view URL] I will want to enter eventually more then 20 sets but this is the starting point. See attachment for example. This should be easy for person who knows excel