=IF(SUM(--(A1:C1=TRANSPOSE(L1:O1)))0,"found one","nope")

the -- converts true/false to 1/0.

If you select (in the formula bar) A1:C1=TRANSPOSE(L1:O1)
and hit the F9 button, you'll see how the helps do each comparison.



" wrote:

Thanks, this seems to work, however I can't say I understand the
formula. I haven't seem the -- before, what does that do? So it looks
like transpose is creating an array, how is checking the array
different than simply checking a range such as L1:O1?

-Andrew

--

Dave Peterson