Selection based on some predefined keywords

[#1]

Hello,

I have a table that contains new-products and its reviews by a set of product users. Please see attached picture Table1.png.

Requirement is to create a hard-coded list box of Positive, Negative and Neutral "Review types". Please see attached picture Review_filter.png

And when I select any 'review type' from the list box, lets say 'Good', the output I should get as a filtered table in attached picture 'Result.png', because, these rows contain 'good' as a comment by at least one of the reviewer.

I want to achieve something like -"Search and Filter".

I hope my requirements are clear. Please help me in achieving this.

Thanks in advance.

[JonnyPoole · Accepted solution]

Here is a sample with your sample data.  The load could be streamlined further in case you had more than 4 reviewers.

With a couple more steps, not hard, you can get condtional background colors and a hierarchical text box too.

Let me know if this is helpful

[#3]

Thanks a ton Jonathan Poole !!