How do I make this lottery checker on excel?

[Lottoguy]

How do I program the excel to show me how many points it did on each line of numbers from this big group of lines.
I copied all the previous 1837 draws from this lottery and its already on my excel spreadsheet. Its a 20 ball number draw from 01-100.
Each of the previous 1837 draws is a line of 20 numbers from A to T.
I need to find out how many points it did on each line when I type my 20 numbers that I chose from 01-100.
If you can help me, teach me how to do it.
thanks.

 

[SteveO59L]

so, you would like to check how many times each of your 20 numbers has been drawn in the previous 1837 draws?

 

[Lottoguy]

Yes, Its what I wanna do. I need to know how many matches my games of 20 numbers from 01-100 did on the previous 1837 draws that I ve recorded on my excel spreadsheet.

 

[SteveO59L]

use countif($a$1:$t$1837,a2000)

assuming your row of numbers start in a2000

 

[Lottoguy]

How do I do that? do will it ask for my numbers to check it?

 

[SteveO59L]

ok, assume your previous draws are in a11:t1847

type your selection into cells a1:t1

in a2 and copied to b2:t2

=countif($a$11:$t$1847,a1)

will count how many times the number in a1:t1, occurs in range a11:t1847

 

[Lottoguy]

I tried to do that but again it didnt work. My range is from A1:T1838
I m still trying to find out how to do it but I donno why its so hard to find it.
I search and search but there s nothing about those tasks on excel.

 

[SteveO59L]

drop me a pm with your email addy, and I will send you a sample

 

[Lottoguy]

I can send you the spreadsheet and the numbers that I wanna test.
I d like to combine to choose one of the previous lines with another one that had more matches with it.
I also do have other questions about lottery work on excel. I ve seen some programs for it but
its very hard to find the code to program the excel to do it. My email is edviper2710@hotmail.com

 

[Lottoguy]

If its a kind of a database work, do you know if I can do in on the ms-access?
I m still looking for my answers to do what I want on excel.