Add a “sort” to a =QUERY statement in Google Spreadsheets

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 d

Related Posts:

  1. Excel to Google Sheets – Error: Formula parse error
  2. How do I filter view two columns OR instead of AND?
  3. Conditional Formatting from another sheet
  4. Substring in excel
  5. What Excel formula returns the sheet name?
  6. Is there Infinity in Spreadsheets?
  7. Declaring variables in Excel Cells
  8. How to loop in excel without VBA or macros?
  9. How to use searchFile and searchFolder at the same time correctly? – App Script
  10. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  11. Using SUBSTITUTE with wildcard characters
  12. Converting time stamps in excel to dates
  13. How to define global variable in Google Apps Script
  14. Google Spreadsheet adding tooltip
  15. Shortcut to Apply a Formula to an Entire Column in Excel
  16. How to label scatterplot points by name?

Leave a Comment