How do I set up a Lottery sydicate checking sheet in excel?
 

There are 50 people who each choose 6 numbers which are entered on a
spreadsheet in Excel next to their name, when the weekly national draw is
made I need to enter the drawn numbers so I can see which of the fifty has 1
or more of them, they will then be noted each week until 1 person gets all 6
numbers and wins the pot!