Excel OR function

B

Bobs82

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?
 
B

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)
 
B

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
 
Top