Michel Sender
Reputation: 81
Problems with Query Command ORDER BY in Google Sheets
I'm working with one Spreadsheet named "geral" (General, in Portuguese), where I saved all informations and the column A saves the Names of the people. I created another sheet just to see some columns from 'Geral' Sheet, and I entered the following formula in A1 cell:
=QUERY(geral!1:994; "select A,F,L,M order by A"; 1)
. It doesn't work, but if I wrote ... order by A desc it works well.
How can I write the query to see the data in "ABC" order, and not just descending?
Upvotes: 8
Views: 11730
Answers (1)
Related Questions
- Google Sheets Order By Query isnt showing any data
- Google Sheets Query, Sort is out of order
- Google Sheets query order by row ends with
- Multiple Sort ( ORDER BY ) within Query in Google Sheets
- Sheets Query No Sort
- Query Function Order by problem Google Sheets
- Google Sheets 'order by' messed up by headers
- Google Sheets query function returns 0 rows when using ORDER By
- Google Sheets Query Ordering not working
- Google Spreadsheet's Query function returns empty data with order by