I have a video game list which contains their Genres in a second column, I've add each genre separated by Comma, all in one cell for each game, and I need a convenient way for viewers to filter (search) Multiple genre values.

Is there any way to make it easy or is there any add-on, script or macro to add such feature?

Image of a part of file: enter image description here



link to file: enter link description here


1 Answer 1


Viewers cannot modify anything in a spreadsheet they have read-only access to, so the only way they can filter data is to use a temporary filter view.

Try conditions like these:

  • Text contains > 3D

  • Custom formula is > =regexmatch(B2:B, "(?i)3D|strategy")

There are also paid add-ons such as Awesome Table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.