View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Enhanced lottery question

The rules of the game are this

Pick 6 numbers and you must keep this six numbers until someone wins.
assume you pick 1, 2, 3, 4, 7, 8

Assume that the lottery numbers in week 1 are
1, 2, 3, 4, 5, 6

You need numbers 7, 8 to win

Assume that the lottery numbers in week 2 are
1, 7, 8, 10, 15, 25

I would like the system to know that you got all 6 numbers correct and won
the game. (The 1 in week two should be ignored - since it was included as a
winning number in week one.)

Any ideas??




In week 1 - assume that you get 4 of the numbers correct - but you are
missing