I'm trying to do a lotto checker in excel 2000 using lines A1 to F6 through to A11 to F11 (11 rows of lotto numbers),I'm having trouble trying to work out a foumula setting to check the numbers after i've entered the weeks no.s so excel will check any matching no.s and highlight them. any advice welcome
Thankyou.
Thankyou.