Hi Everyone,
been trying to figure out how to do this but I can't. I need some help...
I have have a spreadsheet with a sheet called Master.. on it I have listed lotto results:
on another sheet I have each month broken out into years:
above example is only showing month of January with each year... I would like to be able to have a formula that will from the month year sheet go over to the Master sheet and look up how many times each number (across the top, 1 to 60) is pick for each month and year... so for the month of January 2016 it will go to the master sheet for January 2016 and for each of the 5 balls, count how many times each number (1 thru 60) was picked.I If no numbers were pick then put a zero.
Any help is very much appreciated.
Thank you.
been trying to figure out how to do this but I can't. I need some help...
I have have a spreadsheet with a sheet called Master.. on it I have listed lotto results:
on another sheet I have each month broken out into years:
above example is only showing month of January with each year... I would like to be able to have a formula that will from the month year sheet go over to the Master sheet and look up how many times each number (across the top, 1 to 60) is pick for each month and year... so for the month of January 2016 it will go to the master sheet for January 2016 and for each of the 5 balls, count how many times each number (1 thru 60) was picked.I If no numbers were pick then put a zero.
Any help is very much appreciated.
Thank you.