I LIKE TO CREATE A LOTTERY TICKET CHECKER IN OPEN OFFICE.

Eg: the result is 1,4,12,23,31,34 and bonus 20.

my predictor nos: 1,2,4,6,22,23,34 something like that a set of 30 rows.

I need some formula to create a spreadsheet to check and let me knows the hit numbers in the same rows.

I don't understand what you mean by "let me knows the hit numbers in the same rows."Try posting an example of the input numbers and the expected output from those numbers, as well as an explanation as to why the output is what it is.

yes hit numbers in same row.

result 2 4 5 17 23 45 221 2 4 5 17 23 45

2 3 15 17 23 45

Have you tried Google? http://www.computeractive.co.uk/com...

Shows you the formulas.

EDIT:

Here's another example:

http://www.mrexcel.com/forum/showth...

MIKE

thanks you very much for the help which is very useful to me, thank u.

Ask Your Question

Weekly Poll