2

I have a function in Google Sheets that is giving the following output:

a b c
1 2 3

I don't want the a b c I just want the 1 2 3. What function can I wrap around my other function so that it will only show me 1 2 3. I tried array_constrain I want something in the spirit of =ARRAY_CONSTRAIN(A1:C2,2:2,3), but that formula doesn't work.

I just want the 2nd row. The "other function" is a query with aggregates at the top like "avg" and "sum". I don't want to see that. I don't want to hide it because I have to paste down.

  • So, each value is in a separate row/column? – Jacob Jan Tuinstra Feb 23 '15 at 14:42
  • 1
    correct, it is 2 rows x 3 columns – jason Feb 23 '15 at 14:43
  • I curious as to which function gives that result. Can you give us a hint? – Jacob Jan Tuinstra Feb 23 '15 at 14:46
  • I've tried to get rid of the aggregates at the top using the third parameter in the query function, doesn't seem like you can do it. – jason Feb 23 '15 at 14:49
  • The only alternative I can think of is to change each column to a filter function and paste down with averages and sums. It's a really clumsy work around especially if you have alot of columns – jason Feb 23 '15 at 14:53
3

This is what you need to do.

Formula

=QUERY(A1:C2, "SELECT * OFFSET 1", 0)

Explained

The SELECT statement contains an extra OFFSET argument. It tells the query to skip one row. The third parameter of the QUERY formula controls the headers. Setting it to zero will ignore the headers.

  • 1
    wow, clever answer! double query. – jason Feb 23 '15 at 14:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.