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?

Would this work for you?:

=COUNTIF(A1:T1,C17)

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


"Bobs82" wrote:

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?

Are you Ctrl-Shift-Entering the formula?

Can you show the formula?

--

HTH

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


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

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


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