I have a function in Google Sheets that is giving the following output:a b c1 2 3I 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.
Select row in Google Sheets
google spreadsheets
This is what you need to do.Formula=QUERY(A1:C2, SELECT * OFFSET 1, 0)ExplainedThe 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. 