View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JockW JockW is offline
external usenet poster
 
Posts: 32
Default Checking Lotto numbers

Numbers to be checked - A4:F10
Draw numbers - A12:F12

I have tried (in I4) {=IF($A4:$F4=A12,"P","")} which works but only because
the criteria is met in the first column. When copied down and accross it
doesn't work.
Any ideas?

--
tia