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
|