Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 785
Michel Sender Avatar asked Dec 13 '22 14:12

Michel Sender


1 Answers

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

like image 115
pnuts Avatar answered Feb 07 '23 15:02

pnuts