euro millions
 

hello peeps, i'm trying to make a euro millions checker in excel, ive got it
to check the five balls ok but having problems with checking the 2 lucky stars

cell g4 = 3 ( lucky star 1 camerlots No.) cell h4 = 6 ( lucky star 2
camerlots No.)
cell g7 = numbers i put on ( lucky star 1) cell h7 = numbers i put on
(lucky star 2)
cell s7 = total lucky stars ( can only be answer 0,1,2) as you can only mach
the max of 2 balls

can anyone help with a formula please

euro millions
 

Try

=SUMPRODUCT(1-ISNA(MATCH(G7:H7,G4:H4,0)))

"DarkNight" wrote:

hello peeps, i'm trying to make a euro millions checker in excel, ive got it
to check the five balls ok but having problems with checking the 2 lucky stars

cell g4 = 3 ( lucky star 1 camerlots No.) cell h4 = 6 ( lucky star 2
camerlots No.)
cell g7 = numbers i put on ( lucky star 1) cell h7 = numbers i put on
(lucky star 2)
cell s7 = total lucky stars ( can only be answer 0,1,2) as you can only mach
the max of 2 balls

can anyone help with a formula please

euro millions
 

works a treat thanks very much daddylonglegs

"daddylonglegs" wrote:

Try

=SUMPRODUCT(1-ISNA(MATCH(G7:H7,G4:H4,0)))

"DarkNight" wrote:

hello peeps, i'm trying to make a euro millions checker in excel, ive got it
to check the five balls ok but having problems with checking the 2 lucky stars

cell g4 = 3 ( lucky star 1 camerlots No.) cell h4 = 6 ( lucky star 2
camerlots No.)
cell g7 = numbers i put on ( lucky star 1) cell h7 = numbers i put on
(lucky star 2)
cell s7 = total lucky stars ( can only be answer 0,1,2) as you can only mach
the max of 2 balls

can anyone help with a formula please