Tag Info

New answers tagged


Short answer QUERY() allow the use of a subset of SQL but this subset does not include the FROM clause. QUERY() require a single array as the source table, so it could not be used, instead use ARRAYFORMULA(), TRANSPOSE(), JOIN(), SPLIT(), REPT(), FILTER(), COUNTA() and the division (/) and concatenate (&) operators to build a "flexible formula" as ...

Top 50 recent answers are included