How to use filter with multiple criteria in Google Sheet

Question

I'm working with Google Sheet for healthcare purposes organizing patients lists and endorsement to team issues:

=filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission")+('CASES LIST'!Q:Q="pending")+('CASES LIST'!Q:Q="PCI"))

Can I make it shorter like:

=filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission"or"pending"or"pci"))

I want to filter the data if it contains either admission, pending or pci.

Welcome to Web Applications. Please add a brief description of your search/research efforts as is suggested in How to Ask. — Rubén, Jan 6, 2021 at 2:27

marikamitsos · Accepted Answer · 2021-01-06 09:35:12Z

1

Please use the following query formula (adjusting ranges to your needs), instead of the one you already use.

=QUERY({P1:R},"where Col2 matches 'admission|PCI|pending' ",0)

Functions used:

answered Jan 6, 2021 at 9:35

marikamitsos

12.6k3 gold badges27 silver badges54 bronze badges

Have you tried the solution offered? Did it work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well.
– marikamitsos
Jan 6, 2021 at 19:41

Add a comment |

1 Answer 1