Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
hello again, can some one hlep with this formula,
=IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
sorry don not what i'm after. yur formula returns the correct number of
balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
try this idea for 3 matches
=IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
Thats the one .. Cheers Don works a treat
"Don Guillett" wrote: try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
glad to help. I quit playing the Texas Lotto a couple of years ago but I had
a rather involved workbook to keep track. I do custom work. -- Don Guillett SalesAid Software "DarkNight" wrote in message ... Thats the one .. Cheers Don works a treat "Don Guillett" wrote: try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
I'm guessing the one person that can afford to play lotto (Mr. Gates)
doesn't! Why do you suppose that is??? "Don Guillett" wrote: glad to help. I quit playing the Texas Lotto a couple of years ago but I had a rather involved workbook to keep track. I do custom work. -- Don Guillett SalesAid Software "DarkNight" wrote in message ... Thats the one .. Cheers Don works a treat "Don Guillett" wrote: try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
Gee, and I always thought that was how he got his start! -- Don Guillett SalesAid Software "Rookie 1st class" <Rookie1stClass@SpamThis wrote in message ... I'm guessing the one person that can afford to play lotto (Mr. Gates) doesn't! Why do you suppose that is??? "Don Guillett" wrote: glad to help. I quit playing the Texas Lotto a couple of years ago but I had a rather involved workbook to keep track. I do custom work. -- Don Guillett SalesAid Software "DarkNight" wrote in message ... Thats the one .. Cheers Don works a treat "Don Guillett" wrote: try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk lotto dream numbers
Heck ... I thought he got his start from robbin ... er, I mean using the GUI
from Xerox!<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Don Guillett" wrote in message ... Gee, and I always thought that was how he got his start! -- Don Guillett SalesAid Software "Rookie 1st class" <Rookie1stClass@SpamThis wrote in message ... I'm guessing the one person that can afford to play lotto (Mr. Gates) doesn't! Why do you suppose that is??? "Don Guillett" wrote: glad to help. I quit playing the Texas Lotto a couple of years ago but I had a rather involved workbook to keep track. I do custom work. -- Don Guillett SalesAid Software "DarkNight" wrote in message ... Thats the one .. Cheers Don works a treat "Don Guillett" wrote: try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that "Don Guillett" wrote: where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5))) -- Don Guillett SalesAid Software "DarkNight" wrote in message ... hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) |