HI there,
I have a keno results table with 80 columns having numbers from 1 to 80 in Sheet1
I need to create sheet 2 which will link sheet1 to sheet 2.
So when I update sheet1 then sheet 2 should be automatically get updated.
Sheet2 should have Date as the first column and numbers 1 to 10 in the other 10 columns as attached
I would like to filter 1,2,5 and 10 and the rest of the cells be blank as above.
I would like to observe 1,2,5 and 10 for a period of two weeks and find out how many these numbers got hit and on which days.
File link attached : https://filebin.net/iyhniv82c1zi9e05
Thanks
simon
I have a keno results table with 80 columns having numbers from 1 to 80 in Sheet1
I need to create sheet 2 which will link sheet1 to sheet 2.
So when I update sheet1 then sheet 2 should be automatically get updated.
Sheet2 should have Date as the first column and numbers 1 to 10 in the other 10 columns as attached
I would like to filter 1,2,5 and 10 and the rest of the cells be blank as above.
I would like to observe 1,2,5 and 10 for a period of two weeks and find out how many these numbers got hit and on which days.
File link attached : https://filebin.net/iyhniv82c1zi9e05
Thanks
simon