Hey guys, i need a little help... i really need to make a lottery checker, i'm tired of checking ticket by ticket, but i don't know how to make it using numbers 09... Anyone know how to do it? please help me, thanks
Macbook Pro 13, Mac OS X (10.5.8), 4 gb ram, 2.53 ghz intel core 2 duo
I made one of these last time i bought tickets. Just made three tables, one where we enter the ticket numbers, one number per cell, one ticket per row. Then the next one I type in the winning numbers. The last has the same number of rows as the first table, and just checks each cell of the winning table against each corresponding row of the bought tickets. Count number of matches per row, conditional format for winning combinations.
Jason
Ok... so i have to create 2 tables with the same amount of rows, and the 3rd with just 1 row? that's what i did.
I used the count formula and it worked, but the condicional format for winning combinations is not working... i'm doing something wrong... I have to apply it to the same cell that i used the count formula?
What i wanna do is something like this:
lottery number: 15-22-32-33-45-57
My games: 1-2-3-4-5-6 = 0 acertos
3-4-5-6-7-8 = 0 acertos
15-22-32-5-6-7 = 3 acertos
What i have to do to make this possible?
How about this?
For the 2nd table:
G3=SUM(I3:N3)
H3=SUM(I3:N3)
I3=IF(IFERROR(MATCH(A3, Lottery Drawing :: $A$2:$F$2, 0), 0)>0, 1, 0)
select I2 and fill to the right by grabbing the little circle at the bottom right of the selected cell, then drag to the right through N3.... grab mean click and hold)
now select cells G3 through N3, and fill down (again , by grabbing the little circle at the bottom right of the selection and draggin down as needed)
You can hide columns I through N (I left them for completeness)
I hope this helps.
Wayne
Hey Wayne, thanks a lot man... but i keep getting error, do you still have this file? can you send it to me? i'm doing something wrong
What is the error. If you post a screenshot I should be able to solve.
macaple wrote:
Hey Wayne, thanks a lot man... but i keep getting error, do you still have this file? can you send it to me? i'm doing something wrong
Post a screen shot of what you've got, and copies of the formulas you've entered.
Looks like Wayne was in a rush when posting his second formula. I think he intended something like:
H3: =IF(G3>5,"YOU WIN!","Sorry")
Assuming your lottery is a 6/49 type, and has subsidiary prizes for matches of at least 3, a more complete formula would be:
H3: =CHOOSE(G3+1,"Sorry","Sorry","Sorry","minor prize","medium prize","major prize","Jackpot!!")
Regards,
Barry
Yup. Good catch Barry (was trying to get kids to bed):
H3=IF(G3=6, "YOU WIN!", "NO MATCH")
was what I SHOULD have posted
Sure wayne, here it is:
H3=SUM(I3:N3)
H3=IF(G3=6, "YOU WIN", "NO MATCH")
I3=IFERROR(MATCH(A3,Table 2 :: $A$2:$F$2, 0), 0)>0, 1, 0)
And did this after:
I3=IF(IFERROR(MATCH(A3, Lottery Drawing :: $A$2:$F$2, 0), 0)>0, 1, 0)
select I2 and fill to the right by grabbing the little circle at the bottom right of the selected cell, then drag to the right through N3.... grab mean click and hold)
now select cells G3 through N3, and fill down (again , by grabbing the little circle at the bottom right of the selection and draggin down as needed)
Hey guys, i'm sooooo sorry... i forgot to put the IF before ( ) IF(IFERROR(MATCH(A3, Lottery Drawing :: $A$2:$F$2, 0), 0)>0, 1, 0)...
Its working nice now. thanks a lot for the help guys ( Wayne, Barry)
Fairly easy to spot iF you compare your formula directly with Waynes:
I3 (yours): = IFERROR(MATCH(A3,Table 2 :: $A$2:$F$2,0),0 >0, 1, 0)
I3(Wayne): =IF(IFERROR(MATCH(A3,Table 2 :: $A$2:$F$2,0),0)>0, 1, 0)
Table name in Wayne's formula edited to match yours.
Missing part is the IF function and a pair of parentheses (bold).
The underlined zero will appear as "find value" in your formula.
Regards,
Barry
How do i make a lottery checker using numbers 09?
