I m doing a research on lottery results, and I added 2 statistical system together, so I have a spreadsheet with 385 rows
with 10 numbers on each row. The 10 numbers on each row is from 01 to 1317.
I learned how to count the amount of the occurence of each number, but I need to make a table showing the number
of occurences of matched pairs and triples out of all the rows of the spreadsheet.
Maybe there s a macro formula that would do this task but I cant find this macro and nobody has helped me.
Another way I can do it is deleting all the rows that does not have a specific number that I m choosing to find their matches.
Like I can choose the number 16 for example, and automatically the spreadsheet will remove all the rows that does not have
the number 16.
I just wanna have a button that says delete all rows that does not have number X.
My other question is, after counting the number of occurences of all the numbers or results, how do I put the ranking
in order of appearance. Like the numbers/results that has showed up recently will occupy the lower position of the ranking
in that number of occurence, and the longer that a number/result has not showed up it will gradually occupying the upper
position of the ranking. I have seen it at some statistical websites so I d like to learn how to do it by myself.
This question is just making a ranking in order of appearance so I can know how recently or long a number/result has
showed up or not showed up.
I can show ya some examples if you still need more details.
So, help me if you know how to do it. Thanks.
with 10 numbers on each row. The 10 numbers on each row is from 01 to 1317.
I learned how to count the amount of the occurence of each number, but I need to make a table showing the number
of occurences of matched pairs and triples out of all the rows of the spreadsheet.
Maybe there s a macro formula that would do this task but I cant find this macro and nobody has helped me.
Another way I can do it is deleting all the rows that does not have a specific number that I m choosing to find their matches.
Like I can choose the number 16 for example, and automatically the spreadsheet will remove all the rows that does not have
the number 16.
I just wanna have a button that says delete all rows that does not have number X.
My other question is, after counting the number of occurences of all the numbers or results, how do I put the ranking
in order of appearance. Like the numbers/results that has showed up recently will occupy the lower position of the ranking
in that number of occurence, and the longer that a number/result has not showed up it will gradually occupying the upper
position of the ranking. I have seen it at some statistical websites so I d like to learn how to do it by myself.
This question is just making a ranking in order of appearance so I can know how recently or long a number/result has
showed up or not showed up.
I can show ya some examples if you still need more details.
So, help me if you know how to do it. Thanks.
