Lottery check

[IanF]

Hi,

I am in a lottery sindicate at work and we purchase
numerous entries (lines) for each draw. I need a way to
enter the latest draw and let it lookup the lines we have
bought returning how many of the winning numbers appear in
each line.

Is this possible?

Regards
Ian

 

[Don Guillett]

I use conditional formatting.
Say the winning numbers are on row 5 and your numbers are on row 6 & down
format>conditional format>formula is>=sumproduct($B$5:$g$5=b6)*1)>set colors
to be different
then at the end of the row use a formula to count the hits
=IF(F6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
Change the one in col C to c6, etc and then copy the row down.

 

[Biff]

Hi Ian,

I have a workbook that does just what you want. It's based
on the Pennsylvania lottery and includes the Powerball. If
you're interested I can modify a copy for your lottery and
send it to you.

Biff