Help with filter formula

Question

So on Google Sheets, I have this:

=iferror(FILTER('RAW DATA 2'!$B$2:$G,'RAW DATA 2'!$B$2:$B>=$B$1,'RAW DATA 2'!$B$2:$B<=$B$2),""),

The formula is working. However, I would like to skip a column from the range, my range goes from B2:G, and I would like to skip column D from the range, how can I do it?

Answer 1

Use an { array expression }, like this:

=iferror( 
  filter( 
    { 'RAW DATA 2'!B2:C, 'RAW DATA 2'!E2:G }, 
    B1 <= 'RAW DATA 2'!B2:B, 'RAW DATA 2'!B2:B <= B2 
  ) 
)