Replied to Google Sheets Query function: The Most Powerful Function in Google Sheets by an author The ORDER BY clause sorts our data. We can specify column(s) and direction (ascending or descending). It comes after the SELECT and WHERE clauses. 14. Let’s sort our data by population from smallest to largest. Modify your formula to add the following ORDER BY clause, specifying an ascending direction with ASC: =QUERY(countries,"SELECT B, C, D ORDER BY D ASC",1) Ben, is it far to say that ‘Order by’ only ever relates to numerical values? Is there any way of ordering text using a QUERY formula? Does it require the addition of a GROUP BY or a WHERE clause?