=query(A1:S10,"select C,D,E,F,H,K,P,R,S WHERE Q='USA' AND R matches 'Florida|NY|'''
I would like to add (or empty cell) to the 'Florida|NY' That is to say I would like to select rows with the Q= 'USA' and R matches either 'Florida','NY' or empty
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
OR R is null to your