Excel OR function

[Guest]

I have trouble using an array as the argument in the OR function. I have
integer data in some of the locations in array (A1:T1). Unused locations are
blank. Ineed to know if any of the data in the array matches the integer
stored in,for example, C17. So far, everything I try leads to the #VALUE or
#NAME error message. What am I doing wrong?

 

[Guest]

Would this work for you?:

=COUNTIF(A1:T1,C17)

***********
Regards,
Ron

 

[Bob Phillips]

Are you Ctrl-Shift-Entering the formula?

Can you show the formula?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[bernard liengme]

I wonder who can tell Bobs82 what is wrong with his/her formula without
being told what it is!
Why do you need OR, would this work for you =COUNTIF(A1:T1,C17) or
=COUNTIF(A1:T1,C17)>0
best wishes
Bernard