Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

1 vote

Importrange Query importing correct OR statements, but not refining by date

Verify that all the values of TRANSACTIONS!B6:B are dates; otherwise, QUERY might not set this column data type as date, and in such case, it will take the values that don't match the assigned data ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

Importrange Query importing correct OR statements, but not refining by date

TL;DR Use the following updated formula: =QUERY(IMPORTRANGE(R5, "TRANSACTIONS!$A$6:$P1000"), "SELECT Col2, Col3, Col7, Col14, Col15 WHERE (Col3='FEE' OR Col3='WITHDRAWL' OR ...
Blindspots's user avatar
  • 5,597
0 votes

QUERY returns parsing error

Per @Rubén you have a trailing ampersand operator & Your formula should be =QUERY(Sheet1!A1:AC; "WHERE H>="& E11 &" AND I>="& A14 &" AND J>=&...
Blindspots's user avatar
  • 5,597
-1 votes

Import certain columns when one column contains a 5 digit number

=CHOOSECOLS( FILTER( A:O, REGEXMATCH(""& C:C, "\d{5}"), B:B > "4/1/2024" * 1), B:B <= "4/30/2024" * 1) 2, 3, 7, 14, 15) FILTER ...
Blindspots's user avatar
  • 5,597
2 votes

ImportRange Query Formatted Incorrectly

The range B6:P9999 has 15 columns. This explains the error. In other words, B is Col1, C is Col2, and so on. P is Col15.
Rubén - Volunteer Moderator -'s user avatar

Top 50 recent answers are included