By default, the FILTER function in Google Sheets is set up to take multiple criteria using AND logic. With a slight modification, you can make it use OR logic.
After defining your filter array, each criterion will be inside a set of parenthesis followed by a plus sign. Here’s the general format:
=FILTER(array,(column1='something')+(column1='somthing else'))With actual data:
