Return Results of Selected Text in Table

[Borgas]

Hi Forum

I need some help develop a formula for "filter" multiple text in just one result

I have a table of products with multiple categories assigned in same cell

Example Structure

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Product
[/TD]
[TD]Category
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Product 1
[/TD]
[TD]Cat1, Cat2, Cat3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Product 2
[/TD]
[TD]Cat2, Cat3, Cat4
[/TD]
[/TR]
</tbody>[/TABLE]





I have a list of the categories, how can i do another table, just filter for one "Categorie"

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Product
[/TD]
[TD]Category
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Product 1
[/TD]
[TD]Cat2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Product 2
[/TD]
[TD]Cat4
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Borgas]

I have a table where are just the categories i want

Cat2
Cat4

Where the others i don´t want, are "out" of the list