How do I create a =Query(query()) Function in Google Sheets?

Question

I am using the query function to generate content in Sheet 1 pulled from sheets 2-6. I've used this function in past, and its worked quite well – but only when I am pulling from 5 sheets. No more, no less. I do not understand this function as it was taken from an old template. I am interested in creating a new function to serve my purpose and learn how to decipher the meaning of the clauses. Please help.

This is the old function:

=query(query({Sheet2!A1:L;Sheet3!A1:L;Sheet4!A1:L;'Sheet5'!A1:L;Sheet6!A1:L},"select Col1, count(Col1), max(Col4) where Col1 <> 'Testing' group by Col1 order by max(Col4) desc",0), "select * where Col2 > 1",0)

What does each clause mean?

How can I alter it for greater/lesser number of sheets?

Please provide enough code so others can better understand or reproduce the problem. — taylor.2317
– taylor.2317, Commented Feb 7, 2022 at 13:31

player0 · Accepted Answer · 2022-02-02 01:49:00Z

0

make sure this part is correct in your new attempt:

{Sheet2!A1:L; Sheet3!A1:L; Sheet4!A1:L; Sheet5!A1:L; Sheet6!A1:L}

all sheets need to be separated with ; and all ranges needs to have the same number of columns

answered Feb 2, 2022 at 1:49

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I create a =Query(query()) Function in Google Sheets?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related