How to determine whether a list contains a specific value?
 

Does anyone have any suggestions on how to determine whether a list contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric

How to determine whether a list contains a specific value?
 

One way:

=IF(COUNTIF(A1:A10,4)0,1,0)

HTH,
Paul

"Eric" wrote in message
...
Does anyone have any suggestions on how to determine whether a list
contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric

How to determine whether a list contains a specific value?
 

If you mean is 3 (B1) in column A

=IF(countif(A:A,B1)0,1,0)


"Eric" wrote:

Does anyone have any suggestions on how to determine whether a list contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric

How to determine whether a list contains a specific value?
 

I forgot to mention...in my example I used the value 4 instead of 3. See
toppers formula which references the value in B1.
=IF(COUNTIF(A:A,B1)0,1,0)



"PCLIVE" wrote in message
...
One way:

=IF(COUNTIF(A1:A10,4)0,1,0)

HTH,
Paul

"Eric" wrote in message
...
Does anyone have any suggestions on how to determine whether a list
contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric

Thank everyone very much for suggestions
 

Thank everyone very much for suggestions
Eric