Forum Discussion
how to format most frequent combination number result
Hello... I just want to know how to filter the most combination lotto number for the past 2 yrs using microsoft excel spread sheet. Your kind consideration is highly appreciated. best regards, ...
I assume you have your data arranged so that you have a date and a winning lottery number. Add a column with a count( query looking up each number in the last two years of data. Then just sort the data by the value in the count column. Or instead of sorting you could add a pivot table to where you use count as a filter (choosing only the highest value) and display the lottery numbers that fit the highest count