I have a column with 3 options:
Primary Secondary [empty cell]
I am currently using this formula to filter all rows that contain "Primary" from one spreadsheet to another and it's working well.
=query(importrange("https://URL", "CAT!A1:R"), "select * where Col2 = 'Primary'")
I now need to filter rows that are also empty. I can't seem to figure out how to add the second criteria.
Or, what may make more sense, I need to filter for everything but "Secondary".
<>are usually used for "not equals". Did you try that?