Problems with Query Command ORDER BY in Google Sheets

Question

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?

score 22 · Answer 1 · answered Sep 17 '18 at 16:57

22

Look lower down your sheet. Blanks are being sorted first.

answered Sep 17 '18 at 16:57

pnuts

58,317
11
87
139

6

To add, use `"select * where A <> '' or A is not null order by A"` to filter out empty cells – Himmators Oct 03 '18 at 10:21
1

that is embarrassing – ErichBSchulz Feb 27 '21 at 03:51

Problems with Query Command ORDER BY in Google Sheets

1 Answers1