| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Thank everyone very much for suggestions
Thank everyone very much for suggestions
Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the value from a list? | Excel Discussion (Misc queries) | |||
| How to determine the values from a list? | Excel Discussion (Misc queries) | |||
| Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions | |||
| Determine shape name associated with a specific cell | Excel Discussion (Misc queries) | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
Linear Mode
