EXCEL lottery result checker formula

November 7, 2010 at 21:10:43
Specs: Windows Vista
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.

See More: EXCEL lottery result checker formula

Report •


#1
November 8, 2010 at 22:17:37
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.


Report •

#2
November 8, 2010 at 22:33:23
yes hit numbers in same row.
result 2 4 5 17 23 45 22

1 2 4 5 17 23 45
2 3 15 17 23 45


Report •

#3
November 9, 2010 at 05:50:07
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

http://www.skeptic.com/


Report •

Related Solutions

#4
November 9, 2010 at 19:45:31
thanks you very much for the help which is very useful to me, thank u.

Report •


Ask Question