I want to say A1:A60 excluding A20:A30. Is there a minus operator for use with ranges, in Google Sheets?I know that you can take the union of two ranges, like {A1:A19;A31:A60}. I would like to know if there's an operator that excludes one range from another.
What's the formula to select a range excluding a sub-range?
google spreadsheets;formulas
With the following formula it is possible to exclude a certain range:=ARRAYFORMULA(QUERY({ROW(A1:A60), A1:A60}, SELECT Col2 WHERE Col1<20 OR Col1>30))