The number 1 is provided instead of TRUE for brevity.

TEXTJOINconcatenatesthe found colors, separated by commas, and returns a final result.

Note FILTER’snot_foundargument is provided as anempty string("").

Excel formula: Cell contains specific text

SEARCH returns the position offind_textinsidewithin_textas a number.

The output from FILTER is dynamic.

If source data or criteria change, FILTER will return a new set of results.

Excel formula: Get first match cell contains

Excel formula: Count cells that contain specific text

Excel formula: Cell contains one of many things

Excel formula: Highlight cells that contain

Excel formula: Value exists in a range

Excel SEARCH function

Excel ISNUMBER function

Excel FILTER function

Excel TEXTJOIN function