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

Checking Lotto numbers
 

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

Checking Lotto numbers
 

Try this:

Select the range A4:F10
Goto the menu FormatConditional Formatting
Formula Is:

=AND(A4<"",OR(A4=$A$12:$F$12))

Click the Format button
Select the Patterns tab
Select a nice shade of green
OK out

--
Biff
Microsoft Excel MVP


"JockW" wrote in message
...
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

Checking Lotto numbers
 

This seems to work also...

=MATCH(A4,$A$12:$F$12,0)

Rick


"JockW" wrote in message
...
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

Checking Lotto numbers
 

Thanks to all. Not tried any yet but will do.
Cheers.
--
tia


"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