Using query function with (matches) empty cell

Question

=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

score 1 · Accepted Answer · answered Jan 20 '21 at 18:42

1

Add OR R is null to your SELECT statement.

Rubén - Volunteer Moderator -

46,305
18
101
297

Using query function with (matches) empty cell

1 Answers1