So i have a list of values in an array (Color) and cells that may contain those values that are separated by a comer (DATA). I am looking for an equation that can give me either TRUE or FALSE or a Count of instances. Feel a Search and Countifs in there somewhere?
Color | Answer | Data |
Blue | TRUE or 2 | RED,BLUE,GREEN,ORANGE |
Purple | FALSE | Indigo,Violet |
Black | TRUE or 1 | RED,VIOLET,GREEN |
White | ||
Green | ||