In I4, copied down to I10:
=SUMPRODUCT(--(ISNUMBER(MATCH(A4:F4,A$12:F$12,0))))
will return the number of matched/winning numbers in each row
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JockW" wrote:
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