Add a sort to a QUERY statement in Google Spreadsheets

Question

I ve setup a simple  QUERY statement that will pull targeted rows columns out of a  response  sheet and put them into a topic specific sheet    QUERY responses A1 K   Select C  D  E where B contains  2nd Web Design       What I looking for is a way to  automatically sort  the rows being pulled by two methods    Alpha sort rows by one column   Date time sort rows by one column     Any suggestions on how I can modify the above QUERY to automatically sort the rows

User · Accepted Answer

You can use ORDER BY clause to sort data rows by values in columns  Something like   QUERY responses A1 K   Select C  D  E where B contains  2nd Web Design  Order By C  D     If you   d like to order by some columns descending  others ascending  you can add desc asc  ie    QUERY responses A1 K   Select C  D  E where B contains  2nd Web Design  Order By C desc  D

User · Answer

Sorting by C and D needs to be put into number form for the corresponding column  ie 3 and 4  respectively  Eg  Order By 2 asc

[google-sheets] Add a "sort" to a =QUERY statement in Google Spreadsheets

The answer is

Examples related to google-sheets

Examples related to excel-formula

Tags