Google sheets: FILTER, booleans, NOT, ISBLANK
Have you ever had a set of data in Google Sheets where you want to use FILTER to grab rows based on if a condition in one column is met or if a condition is another column is met?
Maybe you got frustrated that the OR function did not work inside the FILTER as you might have expected. Well, let me tell you matey-potatey, ‘or’ works a little differently in FILTER.
In this tutorial, we will explore how to apply alternate ‘or’ conditions in a single column or multiple columns.
NOTE: If you are looking for how to use ‘or’ in a FILTER, I am assuming you know how to use FILTER in Google Sheets.