| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If value is true the check column for specific values
On Jan 22, 2:09*pm, MrPetreli
wrote: Hi I need a formula to check if a column contains specific values it the column contains a certain value if column A:A = string "ABC" then check A:A for string "123" & "456". If "456" is missing then display list missing string in cell b2. -- MrPetreli The following formula seems to get the right answer for the stated example, but I get the feeling there's more to it than that. =IF(COUNTIF(A:A,"ABC")=0,"ABC", IF(COUNTIF(A:A,"123")=0,"123 ","")& IF(COUNTIF(A:A,"456")=0,"456","")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count values in column only if value of another column is true | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Simple Check Box - without True/False values | Excel Discussion (Misc queries) | |||
| how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE | Excel Worksheet Functions | |||
| Check for list of 3 values (alpha) in a column | Excel Programming | |||
Hybrid Mode
