Add a "sort" to a =QUERY statement in Google Spreadsheets

google-sheets excel-formula
Mr. B picture Mr. B · Feb 1, 2014 · Viewed 115.3k times · Source

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.

  1. Alpha sort rows by one column
  2. Date/time sort rows by one column

Any suggestions on how I can modify the above QUERY to automatically sort the rows?

Answer

Pankaj Jaju picture Pankaj Jaju · Feb 1, 2014

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")

Related questions

How to highlight cell if value duplicate in same column for google spreadsheet?

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist me for this query?

Read More
Conditional formatting based on another cell's value

I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color is green …

Read More
How to get the correct range to set the value to a cell?

I want to set text or number in Google Sheet from script. I want to set Hello or number 9 in cell F2. I found this code so far: SpreadsheetApp.getActiveRange().setValue('hello'); but that doesn't specify which cell.

Read More