Match Column Header Place an "X"

[billy60]

Hello,

Can a formula find matching text from column I and place an "X" under the columns J to Y?

I inserted an "X" in first 2 rows showing the results.

Thank you for your help

[davsth]

in J19 =IF(COUNTIF($I19,"*"&J$18&"*"),"X","") copy down and across

or
=IF(ISNUMBER(SEARCH(J$18,$I19,1)),"X","")

or
=IF(SUBSTITUTE($I19,J$18,"",1)=$I19,"","x")

[billy60]

Perfect! Thanks davsth

[DJunqueira]

Visual suggestion for your slicer.

[billy60]

I just formatted with the shapes to filter. Should this be on the VBA post?

[DJunqueira]

No VBA, just a possibility of grouping a shape with slicer.

[billy60]

Okay I think this version will do. Only thing I don't like are display blanks for the slicers though.

So I overlapped bottom row of genre slicers and covered bottom blanks with white colored shape.

Seems to be fine so thanks for all of your help.