Lottery check

  • Thread starter Thread starter IanF
  • Start date Start date
I

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
 
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.
 
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
 
Back
Top