View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bradchap@gmail.com is offline
external usenet poster
 
Posts: 2
Default Need help comparing 6 of 10 numbers

Hi Excel guru's. I need help. I am doing a fundraiser lottery.
People are to pick 10 numbers between 1 and 49, I am then going to
choose 6 random numbers. I need a way of checking the numbers with
the 10 they have picked. I would like to then have it display how
many numbers matched. If you could help me I would greatly appreciate
it.