I need to write a Query formula to pull through unique values from another sheet, excluding rows that contain certain keywords and also excluding any empty rows.

I've written this formula:

=UNIQUE(QUERY('Sheet Name'!A1:AZ,"Select A where A is not null and where not A contains 'STRING'",1))

Unfortunately this gives a VALUE error. It works with either of the 'where' clauses but not with both.

What am I missing?

CodePudding user response：

You don't need to add the seconde 'Where', it just implies that you continue to add conditions into that statement:

=UNIQUE(QUERY('Sheet Name'!A1:AZ,"Select A where A is not null and not A contains 'STRING'",1))